当IDENTITY_INSERT设置为OFF时,不能为表中的标识列插入显式值解决
set identity_insert tableName ON--打开
INSERT INTO tableName
(id,column)
values
(IdValue,cloumnValu
e
)
set identity_insert tableName OFF--关闭
当IDENTITY_INSERT设置为OFF时,不能为表中的标识列插入显式值解决
set identity_insert tableName ON--打开
INSERT INTO tableName
(id,column)
values
(IdValue,cloumnValu
e
)
set identity_insert tableName OFF--关闭