帮我看看这个建表语句
CREATE TABLE [dbo].[SysRole_In_Site](
[Id] [int] IDENTITY(1,1) NOT NULL,
[RoleId] [int] NOT NULL,
[Site] [varchar](50) NOT NULL,
CONSTRAINT [PK_SysRoleInSite] PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY],
CONSTRAINT [IX_SysRole_In_Site] UNIQUE NONCLUSTERED
(
[RoleId] ASC,
[Site] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
怎么在sql server 2000查询分析器中通不过，有什么错误
[解决办法]
CREATE TABLE [dbo].[SysRole_In_Site](
[Id] [int] IDENTITY(1,1) NOT NULL,
[RoleId] [int] NOT NULL,
[Site] [varchar](50) NOT NULL,
CONSTRAINT [PK_SysRoleInSite] PRIMARY KEY CLUSTERED
(
[Id] ASC
) ON [PRIMARY],
CONSTRAINT [IX_SysRole_In_Site] UNIQUE NONCLUSTERED
(
[RoleId] ASC,
[Site] ASC
) ON [PRIMARY]
) ON [PRIMARY]
[解决办法]
你的是在2005中导出的语法吧！2000下不认 WITH 语句
