将一个表的数据复制到另一个

SET IDENTITY_INSERT User ON;

insert into A.dbo.Issue(Id,Name,Age)

select * from B.dbo.Issue

 

SET IDENTITY_INSERT User OFF;

 

参考：

https://www.cnblogs.com/Dongmy/p/16493509.html