DBLink

declare @sql varchar(1000);
set @sql='  select * from openquery(DBLINK2ERP,''select * from MES_USER.ERP_PO_L_FOR_MES where MES_PO_NUM='''''+@number+''''''')   ';
--采购接收对照视图回写到MES
INSERT INTO udt_mm_mes_erp_order  exec(@sql)

select * from openquery(LINK2ERP,'select * from cux_mes_erp_po_headers_iface order by po_number desc'); 
delete from openquery(LINK2ERP,'select * from cux_mes_erp_po_headers_iface where mes_po_number=''190702012'' ');