在执行insert into tpayapply select * from tpayapply时出现如下错误：

Question

set identity_insert on
insert into tpayapply select a,b,.... from tpayapply

Answer 1

SET IDENTITY_INSERT tpayapply ON
insert into tpayapply select * from tpayapply
SET IDENTITY_INSERT tpayapply Off

Answer 2

set identity_insert tpayapply2 on
insert into tpayapply2(id,a,b,....) select id,a,b,.... from tpayapply
set identity_insert off

Answer 3

set identity_insert tpayapply2 on
insert into tpayapply2(id,a,b,....) select * from tpayapply
set identity_insert off