跨库 查询 与 插入

//向本地插入从远程获取的数据
insert into TCMIS.dbo.sys_fmt
select * from OPENDATASOURCE(
         'SQLOLEDB',
         'Data Source=192.168.1.101;User ID=sa;Password=123'
         ).tcmis.dbo.sys_fmt
where 1=1

//向远程插入本地的数据
insert into OPENDATASOURCE(
         'SQLOLEDB',
         'Data Source=192.168.1.101;User ID=sa;Password=123'
         ).tcmis.dbo.sys_fmtfield
select * from TCMIS.dbo.sys_fmtfield where where 1=1