在sql server 中能远程查询更新数据(OPENDATASOURCE) 不经常使用的数据可以用OPENDATASOURCE,openrowset等来引用,如果数据经常使用那么你最好使用链接服务来进行分布式查询更新 update OPENDATASOURCE ( ' SQLOLEDB ' , ' Data Source = 192.168.1.6;User ID = sa;Password =test ' ).test.dbo.orders set ship_to = ' asdfasdf ' where order_no = 1 select * from OPENDATASOURCE ( ' SQLOLEDB ' , ' Data Source = 192.168.1.6;User ID = sa;Password =test ' ).test.dbo.orders where order_no = 1 delete from OPENDATASOURCE ( ' SQLOLEDB ' , ' Data Source = 192.168.1.6;User ID = sa;Password =test ' ).test.dbo.orders where order_no = 1