sql server 远程引用
在sql server 中能远程查询更新数据(OPENDATASOURCE)不经常使用的数据可以用OPENDATASOURCE,openrowset等来引用，如果数据经常使用那么你最好使用链接服务来进行分布式查询更新http://www.blogdriver.com/jsp/face/53.gif
http://hgq0011.iyunv.com/Images/OutliningIndicators/None.gifupdate OPENDATASOURCE(
http://hgq0011.iyunv.com/Images/OutliningIndicators/None.gif 'SQLOLEDB',
http://hgq0011.iyunv.com/Images/OutliningIndicators/None.gif 'Data Source = 192.168.1.6;User ID = sa;Password =test'
http://hgq0011.iyunv.com/Images/OutliningIndicators/None.gif ).test.dbo.orders set ship_to = 'asdfasdf' where order_no = 1
http://hgq0011.iyunv.com/Images/OutliningIndicators/None.gif
http://hgq0011.iyunv.com/Images/OutliningIndicators/None.gifselect * from OPENDATASOURCE(
http://hgq0011.iyunv.com/Images/OutliningIndicators/None.gif 'SQLOLEDB',
http://hgq0011.iyunv.com/Images/OutliningIndicators/None.gif 'Data Source = 192.168.1.6;User ID = sa;Password =test'
http://hgq0011.iyunv.com/Images/OutliningIndicators/None.gif ).test.dbo.orders where order_no = 1
http://hgq0011.iyunv.com/Images/OutliningIndicators/None.gifdelete from OPENDATASOURCE(
http://hgq0011.iyunv.com/Images/OutliningIndicators/None.gif 'SQLOLEDB',
http://hgq0011.iyunv.com/Images/OutliningIndicators/None.gif 'Data Source = 192.168.1.6;User ID = sa;Password =test'
http://hgq0011.iyunv.com/Images/OutliningIndicators/None.gif ).test.dbo.orders where order_no = 1
http://hgq0011.iyunv.com/Images/OutliningIndicators/None.gif
页:
[1]