创建表出现错误，求解。

[kevinjay567]

这样创建一张表，为何报出
Server: Msg 170, Level 15, State 1, Line 10
Line 10: Incorrect syntax near '('.
错误。

SET ANSI_NULLS OFF
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING OFF
GO

CREATE TABLE [dbo].[Datatemp](
[AA] [smallint] NOT NULL,
[BB] [char](30) NOT NULL,
[CC] [char](80) NOT NULL,
[DD] [char](80) NOT NULL,
CONSTRAINT [Cons_ Datatemp] PRIMARY KEY CLUSTERED
(
[AA] 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

[jwdream2008]

2005中测试，无问题！

[「已注销」]

sql server2008 没问题

[abuying]

CREATE TABLE [dbo].[Datatemp](
[AA] [smallint] NOT NULL,
[BB] [char](30) NOT NULL,
[CC] [char](80) NOT NULL,
[DD] [char](80) NOT NULL,
 CONSTRAINT [Cons_ Datatemp] PRIMARY KEY CLUSTERED  
(
[AA] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) --去掉ON [PRIMARY]
) ON [PRIMARY]

[shizheyangde]

[Quote=引用 2 楼 zsh0809 的回复:]
sql server2008 没问题
[/Quote]
无问题

[claro]

请转去MySQL版问，thx！

[pengpeng409]

呵呵。。。。。。。。

[kevinjay567]

是啊，我也觉得没问题，但是sql2008还是会报出
Server: Msg 170, Level 15, State 1, Line 9
Line 9: Incorrect syntax near '('.
不知道是什么原因

[kevinjay567]

SQL2008,2005没问题，SQL2000就会有问题

[橡胶轮胎行业数字化高总]

生成2000的语句执行吧。2005和2000的语法不一样。