把主机上表test跟新到本地test表:
主机表test如
fid fname fnumber fuser
1 a 001 52 b 002 6
本地表如
fid fname fnumber fuser
1 x 001 5更新完本地test表结果为
fid fname fnumber fuser
1 a 001 52 b 002 6
主机表test如
fid fname fnumber fuser
1 a 001 52 b 002 6
本地表如
fid fname fnumber fuser
1 x 001 5更新完本地test表结果为
fid fname fnumber fuser
1 a 001 52 b 002 6
2.在本地服务器,
insert into test
select b.* from link.db..test a
where not exists(select 1 from test b where a.fid=b.fid)