链接数据库
exec sp_addlinkedserver 'YTD_SERVER_lnk','','SQLOLEDB','220.162.244.127'
exec sp_addlinkedsrvlogin 'YTD_SERVER_lnk','false',null,'admin','pwd'
select TradeId,Bargain_Code,Cust_LinkMan from YTD_SERVER_lnk.YTD_SERVER.dbo.V_A_Bargain where Cust_LinkMan<>''
exec sp_addlinkedsrvlogin 'YTD_SERVER_lnk','false',null,'admin','pwd'
select TradeId,Bargain_Code,Cust_LinkMan from YTD_SERVER_lnk.YTD_SERVER.dbo.V_A_Bargain where Cust_LinkMan<>''