insert into tb
select * from
openrowset('sqloledb','192.168.18.254';
'wgswgs';'wgswgs','select * from dbname.dbo.tbname where 条件')
select * from
openrowset('sqloledb','192.168.18.254';
'wgswgs';'wgswgs','select * from dbname.dbo.tbname where 条件')
select * from
openrowset('sqloledb','serverip';'uid';'pwd',
'select * from dbname.dbo.tbname where 条件')