sqlserver插入语句报错。。。好纠结

Question

Cannot insert explicit value for identity column in table '表名' when IDENTITY_INSERT is set to OFF

Answer 1

问题:sql Insert的时候报的错误.
分析:要插入的表中有自增字段.
解决:跳过此自增字段不插入.
例如:tableA中的a为自增字段
insert into tableA(a,b,c)
select b,c from tableB