跨数据库访问(局域网内)

select 'D01' outlet_id,department_id,name
FROM      OPENDATASOURCE(
         'SQLOLEDB',
         'Data Source=10.0.0.50;User ID=sa;Password=password'
         ).distcenter.dbo.department