set identity_insert TabloA on -- if there is no primary key on the table else off
insert into DB1.dbo.TabloA(kolon1,kolon2) select kolon1,kolon2 from DB2.dbo.TabloB
insert into resources (id,owner,editor,value,edited,title,created,type,discarded,parentId,rank,size,tags) select id,owner,editor,value,edited,title,created,type,discarded,parentId,rank,size,tags FROM testDB.resources
insert into DB1.dbo.TabloA(kolon1,kolon2) select kolon1,kolon2 from DB2.dbo.TabloB
insert into resources (id,owner,editor,value,edited,title,created,type,discarded,parentId,rank,size,tags) select id,owner,editor,value,edited,title,created,type,discarded,parentId,rank,size,tags FROM testDB.resources
Yorumlar
Yorum Gönder