create table tblAuditLog(
AuditLogID int IDENTITY(1,1) not null,
Action varchar(20) not null,
Msg varchar(100) null,
AuditDate datetime null
constraint DF_tblAuditLog_ErrorDate Default (getdate()),
constraint [PK_tblAuditLog] primary key clustered (AuditLogID) ON PRIMARY
)on primary执行到“constraint [PK_tblAuditLog] primary key clustered (AuditLogID) ON PRIMARY”该句提示如下:
服务器: 消息 156,级别 15,状态 1,行 7
在关键字 'PRIMARY' 附近有语法错误。
AuditLogID int IDENTITY(1,1) not null,
Action varchar(20) not null,
Msg varchar(100) null,
AuditDate datetime null
constraint DF_tblAuditLog_ErrorDate Default (getdate()),
constraint [PK_tblAuditLog] primary key clustered (AuditLogID) ON PRIMARY
)on primary执行到“constraint [PK_tblAuditLog] primary key clustered (AuditLogID) ON PRIMARY”该句提示如下:
服务器: 消息 156,级别 15,状态 1,行 7
在关键字 'PRIMARY' 附近有语法错误。
create table tblAuditLog(
AuditLogID int IDENTITY(1,1) not null,
Action varchar(20) not null,
Msg varchar(100) null,
AuditDate datetime null
constraint DF_tblAuditLog_ErrorDate Default (getdate()),
constraint [PK_tblAuditLog] primary key clustered (AuditLogID)
)on [primary]
AuditLogID int IDENTITY(1,1) not null constraint [PK_tblAuditLog] primary key clustered (AuditLogID),
Action varchar(20) not null,
Msg varchar(100) null,
AuditDate datetime null
constraint DF_tblAuditLog_ErrorDate Default (getdate()),
)
AuditLogID int IDENTITY(1,1) not null,
Action varchar(20) not null,
Msg varchar(100) null,
AuditDate datetime null
constraint DF_tblAuditLog_ErrorDate Default (getdate()),
constraint [PK_tblAuditLog] primary key clustered (AuditLogID) ON [PRIMARY]
)on [primary]
AuditLogID int IDENTITY(1,1) not null,
Action varchar(20) not null,
Msg varchar(100) null,
AuditDate datetime null
constraint DF_tblAuditLog_ErrorDate Default (getdate()),
constraint [PK_tblAuditLog] primary key clustered (AuditLogID)
)
AuditLogID int IDENTITY(1,1) not null,
Action varchar(20) not null,
Msg varchar(100) null,
AuditDate datetime null
constraint DF_tblAuditLog_ErrorDate Default (getdate()),
constraint [PK_tblAuditLog] primary key clustered (AuditLogID))ON [PRIMARY]--沒有指定主健索引設置,去掉一個ON [PRIMARY]
create table tblAuditLog(
AuditLogID int IDENTITY(1,1) not null,
Action varchar(20) not null,
Msg varchar(100) null,
AuditDate datetime null
constraint DF_tblAuditLog_ErrorDate Default (getdate()),
constraint [PK_tblAuditLog] primary key clustered (AuditLogID)
)