SET IDENTITY_INSERT Db1.dbo.[B] ON insert into db1.dbo.[B] select * from db2.dbo.[A] where reqid = 201 SET IDENTITY_INSERT db1.dbo.[B] OFF
Insert into db1.dbo.table1 select * from db2.dbo.table2
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)