SQLServer -＞ SQL2008链接其他数据库（链接服务器）

步骤1.

步骤2.

步骤3.

 步骤4.

步骤5.

案例：

1.使用链接查询

--案例
--exec   sp_addlinkedserver     'srv_lnk','','SQLOLEDB','192.168.2.168'  
--exec   sp_addlinkedsrvlogin   'srv_lnk','false',null,'sa','aa1374827277' 
  
--select   *   from  openquery(192.168.2.153).sanqi.dbo.Img  
--openquery 
--select * from [2222].sanqi.dbo.Img 
--select * from srv_lnk.sanqi.dbo.Img 
--select * from [121数据库].[XYDBOfSHLY].dbo.APBil
--select APOBil.SupplyID,APOBil.APOID,APOBil.InDate as '订购日期',APOBil.APID as '请购凭证',APOBil.Des as '要求说明',APOBil.Maker as '经办人',APOBil.Auther as '审核人',APOBil.Supply as '供方单位',APOBil.STel as '电话',APOBil.SFax as '传真',Supply.MContact as '联系人' from [121数据库].[XYDBOfSHLY].dbo. APOBil as  APOBil  left join [121数据库].[XYDBOfSHLY].dbo.Supply  as Supply on Supply.SupplyID=APOBil.SupplyID
 --select * from [121数据库].[XYDBOfSHLY].dbo. APOBil as  APOBil  left join [121数据库].[XYDBOfSHLY].dbo.Supply  as Supply on Supply.SupplyID=APOBil.SupplyID
 select APOID as '采购单号',MName as '品名',Scale as '规格',CalUnit as '单位',Acount as '数量',Price as '单价',SumPrice as '金额',DeliveryDate as '交货日期',PNum as '工单号',rank() OVER (ORDER BY APOID desc) rank,APODetail.InMSerial as '序号' from [121数据库].[XYDBOfSHLY].dbo.APODetail as APODetail order by APODetail.InMSerial asc

2.利用链接服务器自动创建表并存储数据

select  * into  formmain_51088 from oa.v3x.dbo.formmain_51088
oa.v3x.dbo.formmain_51088是链接服务器里面存在的表，formmain_51088是要创建的表

参考:

1.SQL Server跨服务器操作数据库——通过链接服务器(LinkedServer)实现SQL Server远程链接MySql等数据库

SQL Server跨服务器操作数据库——通过链接服务器(LinkedServer)实现SQL Server远程链接MySql等数据库 - 亟待! - 博客园