Question

SQLServer '(' 附近有语法错误。

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [Accounts_UserType](
[UserType] [char](2) COLLATE Chinese_PRC_CI_AS NOT NULL,
[Description] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
CONSTRAINT [PK_Accounts_UserType] PRIMARY KEY CLUSTERED
(
[UserType] 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

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

在复制表结构时 每张表都出这个错误 '(' 附近有语法错误。 请问是为什么啊
括号没有错误，在分析时没错，执行的时候就报错了

Answer 1

你总共用了两个（）（），但是第一个括号只有（ 没有后面的部分）

Answer 2

GO
SET ANSI_PADDING OFF
前面加个)看看.

Answer 3

正确的是
SET ANSI_PADDING ON
GO
CREATE TABLE [Accounts_UserType](
[UserType] [char](2) COLLATE Chinese_PRC_CI_AS NOT NULL,
[Description] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
CONSTRAINT [PK_Accounts_UserType] PRIMARY KEY CLUSTERED
(
[UserType] 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