服务器: 消息 170,级别 15,状态 1,行 18
第 18 行: '(' 附近有语法错误。CREATE TABLE [dbo].[admins](
[idAdmin] [int] IDENTITY(1,1) NOT NULL,
[adminName] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[adminPassword] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[adminLevel] [int] NULL DEFAULT ((0)),
[lastLoginDate] [datetime] NULL,
[idGroup] [int] NULL DEFAULT ((0)),
[idAffiliate] [int] NULL DEFAULT ((0)),
[department] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[userName] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[lastLoginIP] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[logintimes] [int] NULL DEFAULT ((0)),
[active] [int] NULL DEFAULT ((0)),
[lockIP] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
CONSTRAINT [PK_admins] PRIMARY KEY CLUSTERED
(
[idAdmin] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
第 18 行: '(' 附近有语法错误。CREATE TABLE [dbo].[admins](
[idAdmin] [int] IDENTITY(1,1) NOT NULL,
[adminName] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[adminPassword] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[adminLevel] [int] NULL DEFAULT ((0)),
[lastLoginDate] [datetime] NULL,
[idGroup] [int] NULL DEFAULT ((0)),
[idAffiliate] [int] NULL DEFAULT ((0)),
[department] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[userName] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[lastLoginIP] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[logintimes] [int] NULL DEFAULT ((0)),
[active] [int] NULL DEFAULT ((0)),
[lockIP] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
CONSTRAINT [PK_admins] PRIMARY KEY CLUSTERED
(
[idAdmin] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
[idAdmin] [int] IDENTITY(1,1) NOT NULL,
[adminName] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[adminPassword] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[adminLevel] [int] NULL DEFAULT ((0)),
[lastLoginDate] [datetime] NULL,
[idGroup] [int] NULL DEFAULT ((0)),
[idAffiliate] [int] NULL DEFAULT ((0)),
[department] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[userName] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[lastLoginIP] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[logintimes] [int] NULL DEFAULT ((0)),
[active] [int] NULL DEFAULT ((0)),
[lockIP] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
CONSTRAINT [PK_admins] PRIMARY KEY CLUSTERED
(
[idAdmin] ASC
) ON [PRIMARY]
) ON [PRIMARY]