局域网 跨数据库 访问数据库

select docno from opendatasource( 'SQLOLEDB','Data Source=192.168.0.2;User ID=sa;Password=123456' )...tab_a

SELECT * FROM OPENROWSET('SQLOLEDB','192.168.0.2';'sa';'123456','SELECT * FROM dbo.tab_a')