链接数据库

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<>''
posted @ 2008-05-18 22:14  熊忠荣  阅读(152)  评论(0编辑  收藏  举报