SQL-跨機器 OPENQUERY

AddLinkServer 開

INSERT OPENQUERY (trovta, 'SELECT ac_proj,ac_proja,pr_dp_no,ma_dp_no FROM ICDB1.iemis.iepb17h')

select cmsc_proj,left(proj_name,40),pr_dp_no,ma_dp_no from ixERP003_1 where

cmsc_proj not in (select * FROM openquery(trovta, 'SELECT ac_proj FROM ICDB1.iemis.iepb17h '));

AddLinkServer 關