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

select 'D01' outlet_id,department_id,name
FROM      OPENDATASOURCE(
         'SQLOLEDB',
         'Data Source=10.0.0.50;User ID=sa;Password=password'
         ).distcenter.dbo.department
posted @ 2006-11-30 15:15  kuailewangzi1212  阅读(261)  评论(0编辑  收藏  举报