create table [SmartSchedule].dbo.[Task]
(
[Task_ID][bigint]identity(1,1)not null,
[Title][nvarchar](256)collate Chinese_PRC_CI_AS not null,
[Detail][nvarchar](8000)collate Chinese_PRC_CI_AS null,
[BeginTime][DateTime]not null,
[NeedNotify][int]not null,
[Finished][int]not null,
[Type][bigint]not null,
[Priority][bigint]not null
)on[primary]
(
[Task_ID][bigint]identity(1,1)not null,
[Title][nvarchar](256)collate Chinese_PRC_CI_AS not null,
[Detail][nvarchar](8000)collate Chinese_PRC_CI_AS null,
[BeginTime][DateTime]not null,
[NeedNotify][int]not null,
[Finished][int]not null,
[Type][bigint]not null,
[Priority][bigint]not null
)on[primary]
(
[Task_ID][bigint]identity(1,1)not null,
[Title][nvarchar](256)collate Chinese_PRC_CI_AS not null,
[Detail][nvarchar](4000)collate Chinese_PRC_CI_AS null,
[BeginTime][DateTime]not null,
[NeedNotify][int]not null,
[Finished][int]not null,
[Type][bigint]not null,
[Priority][bigint]not null
)on[primary]
(
[Task_ID][bigint]identity(1,1)not null,
[Title][nvarchar](256)collate Chinese_PRC_CI_AS not null,
[Detail][nvarchar](4000)collate Chinese_PRC_CI_AS null,
[BeginTime][DateTime]not null,
[NeedNotify][int]not null,
[Finished][int]not null,
[Type][bigint]not null,
[Priority][bigint]not null
)on[primary]
go警告: 已创建表 'Task',但其最大行大小(8577)超过了每行的最大字节数(8060)。如果结果行长度超过 8060 字节,则此表中行的 INSERT 或 UPDATE 将失败。