insert into code select * from tempcode

Question

SET IDENTITY_INSERT [ database.[ owner.] ] { table } { ON | OFF }

Answer 1

code表中定义了identity列1.不插入identity列insert into code(column1,column2,...) select column1,column2,.. from tempcode
显式的写出所有列名,不包括identity列2.插入identity列set identity_insert on
insert into code select * from tempcode 
set identity_insert off

Answer 2

第2点修正一下SET IDENTITY_INSERT code on
insert into code select * from tempcode 
set identity_insert code off