update server2.db2.table2 set filed2=server1.db1.table1.filed from server1.db1.table1 where server2.db2.table2.编号=server1.db1.table1.编号
update a set 列=b.filed from server2.db2.table2 a,server1.db1.table1 b where a.编号=b.编号
假设当前连接的服务器是server1 如果已经创建到server2的链接服务器,可以用:update db1.table1 set filed=b.field2 from table1 a join server2.db2.table2 b on a.关键字段=b.关键字段
或者:update openrowset('sqloledb','server2';'sa';'',db2.dbo.table2) set field2=b.field openrowset('sqloledb','server2';'sa';'',db2.dbo.table2) a inner join openrowset('sqloledb','server1';'sa';'',db1.dbo.table1) b on a.关键字段=b.关键字段
如果已经创建到server2的链接服务器,可以用:update db1.table1 set filed=b.field2
from table1 a join server2.db2.table2 b on a.关键字段=b.关键字段
set field2=b.field
openrowset('sqloledb','server2';'sa';'',db2.dbo.table2) a
inner join
openrowset('sqloledb','server1';'sa';'',db1.dbo.table1) b
on a.关键字段=b.关键字段