请问下面哪里有错，并帮解释一下这几个英文

[mailto520]

use tms
set ANSI_NULLS ON
GO
CREATE TABLE [dbo].[Users](
[UserID][int]IDENTITY(1,1) NOT NULL,
[UserName][nvarchar](16)Collate chinese_prc_ci_as not null,
[UserPwd][nvarchar](12)collate chinese_prc_ci_as not null,
[UserType][nvarchar](50)Collate chinese_prc_ci_as not null,
constraint [PK_Users] primary key clustered
([UserID] asc
)with(ignore_dup_key=off)on [primary]
)on [primary]

[nalnait]

貌似没错啊

[mailto520]

服务器: 消息 170，级别 15，状态 1，行 8
第 8 行: '(' 附近有语法错误。

[等不到来世]

没发现错误，能正常创建。。
加个go看看：

use tms
go
set ANSI_NULLS ON 
GO 
CREATE TABLE [dbo].[Users]( 
[UserID][int]IDENTITY(1,1) NOT NULL, 
[UserName][nvarchar](16)Collate chinese_prc_ci_as not null, 
[UserPwd][nvarchar](12)collate chinese_prc_ci_as not null, 
[UserType][nvarchar](50)Collate chinese_prc_ci_as not null, 
constraint [PK_Users] primary key clustered 
([UserID] asc 
)with(ignore_dup_key=off)on [primary] 
)on [primary] 

[-晴天]

ignore_dup_key=off 本来就是默认的,如真的有错可以去掉该设置:

CREATE TABLE [dbo].[Users]( 
[UserID][int]IDENTITY(1,1) NOT NULL, 
[UserName][nvarchar](16)Collate chinese_prc_ci_as not null, 
[UserPwd][nvarchar](12)collate chinese_prc_ci_as not null, 
[UserType][nvarchar](50)Collate chinese_prc_ci_as not null, 
constraint [PK_Users] primary key clustered 
([UserID] asc) 
)on [primary] 
go
drop table users

[rimm2008]

使用 SQL2000? 去掉 ignore_dup_key 吧

[rucypli]

with(ignore_dup_key=off)去掉