解决往数据库插入数据时报错的问题

原始SQL：

insert into yuJXZhB(ID,yuJXM,yuJXMMC,yuJXSh,biaoZhZh,zuiDZh,zuiXZh,fuDZh,yuJMSh,yuJDJ,gongAnBSh,jTbSh,status) values(1,'ZhuChZhD','驻车制动','提示',60,80,40,20,1,2,1,2,1);

 

报错详情：[SQL Server] 当IDENTITY_INSERT 设置为OFF时，不能为表 'yuJXZhB' 中的标识列插入显示值

 

解决方案：加入关键字  "set identity_insert yuJXZhB ON;'" 和  "set identity_insert yuJXZhB OFF;"，加入关键字后的SQL语句为：

set identity_insert yuJXZhB ON;

insert into yuJXZhB(ID,yuJXM,yuJXMMC,yuJXSh,biaoZhZh,zuiDZh,zuiXZh,fuDZh,yuJMSh,yuJDJ,gongAnBSh,jTbSh,status) values(1,'ZhuChZhD','驻车制动','提示',60,80,40,20,1,2,1,2,1);

set identity_insert yuJXZhB OFF;

这样就可以了。