客户将表中的数据删除之后,再次插入提示Only if specified in the column list and SET IDENTITY_INSERT is ON, then identity column could be assigned value
解决办法:
set IDENTITY_INSERT schema_name.table_name on;
insert into table(col1,col2) values(1,2);
set IDENTITY_INSERT schema_name.table_name off;
文章
阅读量
获赞