Quote:
USE [MU2003_EVENT_DATA]
GO
/****** Object: Table [dbo].[T_PCBANG_POINT_INFO] Script Date: 04/07/2010 19:41:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[T_PCBANG_POINT_INFO](
[memb___id] [varchar](10) NOT NULL,
[PCBangPoint] [int] NOT NULL,
[Hour] [smallint] NULL,
[Year] [smallint] NULL,
[Month] [smallint] NULL,
[Day] [smallint] NULL,
CONSTRAINT [PK_T_PCBANG_POINT_INFO] PRIMARY KEY CLUSTERED
(
[memb___id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[T_PCBANG_POINT_INFO] ADD CONSTRAINT [DF_T_PCBANG_POINT_INFO_PCBangPoint] DEFAULT ((0)) FOR [PCBangPoint]
GO
it gives me the following error :
Quote:
Server: Msg 170, Level 15, State 1, Line 12
Line 12: Incorrect syntax near '('.
. thanks for Help.