–1、如果两库同机
insert into dbnameb.dbo.tb select * from dbnamea.dbo.tb
–2、如果两库不同机,先按照11做链接。然后
insert into machinenameb.dbnameb.dbo.tb select * from machinenamea.dbnamea.dbo.tb
–1、如果两库同机
insert into dbnameb.dbo.tb select * from dbnamea.dbo.tb
–2、如果两库不同机,先按照11做链接。然后
insert into machinenameb.dbnameb.dbo.tb select * from machinenamea.dbnamea.dbo.tb