示例:使用192.168.18.254数据库服务器中,数据库test中的Orders表数据
select * from OPENDATASOURCE('SQLOLEDB','Data Source=192.168.18.254;User ID=sa;Password=).test.dbo.Orders
select * from OPENDATASOURCE('SQLOLEDB','Data Source=192.168.18.254;User ID=sa;Password=).test.dbo.Orders