sqlserver:
update a set a.fenqu=b.fenqu
from j2_unitcode a
inner join j2_unitcode_bak b
on a.code=b.code and len(b.code)=6 and len(isnull(b.fenqu,''))>0
1、在目的数据库上,创建dblinkdrop public database link dblink_orc92_182;Create public DATABASE LINK dblink_orc92_182 CONNECT TO bst114 IDENTIFIED BY password USING ''orc92_192.168.254.111'';--dblink_o...