打開遠程數據庫表

1.訪問遠程數據庫表

select * from

OpenDataSource( 'SQLOLEDB','server=prince;User ID=sa;Password=').POWER_JX.dbo.[CnToEn]

==================================>

1269 STOCK RepSetUp fmReportSetUp 0 (英) (E)
1289 STOCK RepSetUp fmReportSetUp 0 ISO文件編號 ISO File NO.
1288 STOCK RepSetUp fmReportSetUp 0 ISO編號是否列印 Print ISO NO.
1268 STOCK RepSetUp fmReportSetUp 0 （中） (C)
1263 STOCK RepSetUp fmReportSetUp 0 不列印 Not Print
1265 STOCK RepSetUp fmReportSetUp 0 中文 Chinese

2.訪問本地不同數據表

select * from POWER8_EN.dbo.scm04