3 如果有了link server可以使用openquery,或者可以直接使用openrowset(不需要link server)
如:
insert into dbo.gwkh
select * from openrowset
('MSDASQL',
'emaoe_export';
'emaoe_export';
'emaoe_export',
'select distinct companyname from dbo.cw_fcompany')
where companyname not in (select khmc from gwkh)