sql server 跨库操作 

insert into 表A  select * from OPENDATASOURCE(
         'SQLOLEDB','Data Source=192.168.0.1;User ID=sa;Password=sa'
         ).databasename.dbo.表B  where id  not in (select id from 表A)

 

posted @ 2017-06-07 09:13  simadi  阅读(257)  评论(0)  编辑  收藏  举报