1.彼此建立链接服务器 sp_addlinkserver 2.使用下面的语句 1).在A上增加 Insert INTO A(COL1,COL2.....) SELECT * FROM B WHERE CHECKSUM(*) not in (SELECT CHECKSUM(*) FROM A) 2)在B上增加 Insert INTO B(COL1,COL2.....) SELECT * FROM A WHERE CHECKSUM(*) not in (SELECT CHECKSUM(*) FROM B)
1、建立连接服务器,方便一点(当然可以有其他方法代替) 2、insert into tb select * from ta where not exists(select 1 from tb where ta.id=tb.id) 之类的形式
2.使用下面的语句
1).在A上增加
Insert INTO A(COL1,COL2.....)
SELECT * FROM B
WHERE CHECKSUM(*) not in (SELECT CHECKSUM(*) FROM A)
2)在B上增加
Insert INTO B(COL1,COL2.....)
SELECT * FROM A
WHERE CHECKSUM(*) not in (SELECT CHECKSUM(*) FROM B)
2、insert into tb
select * from ta where not exists(select 1 from tb where ta.id=tb.id)
之类的形式