//向本地插入从远程获取的数据
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