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)