CREATE TABLE Test(
ID INT PRIMARY KEY IDENTITY,
Name VARCHAR(40),
);SET IDENTITY_INSERT Test ONINSERT INTO test VALUES (6,'League One');SET IDENTITY_INSERT Test OFF
结果出现下面这段话Msg 8101, Level 16, State 1, Line 8
An explicit value for the identity column in table 'test' can only be specified when a column list is used and IDENTITY_INSERT is ON.
我已经把IDENTITY_INSERT 设置成ON了啊,怎么回事啊?
我单独运行IDENTITY_INSERT 的时候也显示代码运行成功的啊。用的是SQL2008 R2,跟版本有关吗?
ID INT PRIMARY KEY IDENTITY,
Name VARCHAR(40),
);SET IDENTITY_INSERT Test ONINSERT INTO test VALUES (6,'League One');SET IDENTITY_INSERT Test OFF
结果出现下面这段话Msg 8101, Level 16, State 1, Line 8
An explicit value for the identity column in table 'test' can only be specified when a column list is used and IDENTITY_INSERT is ON.
我已经把IDENTITY_INSERT 设置成ON了啊,怎么回事啊?
我单独运行IDENTITY_INSERT 的时候也显示代码运行成功的啊。用的是SQL2008 R2,跟版本有关吗?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货