34,589
社区成员
发帖
与我相关
我的任务
分享
Select top 1 * From OPENDATASOURCE('SQLOLEDB','Data Source=xyingsc01;User ID=1981;Password=852'
).ld.dbo.cpbm
Left Join
OPENDATASOURCE('SQLOLEDB','Data Source=C900;User ID=sa;Password=x3500'
).UFDATA_808_2012.dbo.Inventory
On cpbm.成品编码=Inventory.cInvDefine4
----------------------------------------
消息 17,级别 16,状态 1,第 2 行
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server 不存在或拒绝访问。
Select top 1 * From OPENDATASOURCE('SQLOLEDB','Data Source=xyingsc01;User ID=1981;Password=852').ld.dbo.cpbm a
Left Join
OPENDATASOURCE('SQLOLEDB','Data Source=10.20.1.99;User ID=sa;Password=x3500').UFDATA_808_2012.dbo.Inventory b
On a.产品编码 =b.cInvAddCode
select top 1 * from openrowset( 'SQLOLEDB', 'xyingsc01'; '1981'; '852',ld.dbo.cpbm)a
left join
openrowset( 'SQLOLEDB', '10.20.1.99'; 'sa'; 'x3500',UFDATA_808_2012.dbo.Inventory)b
On a.产品编码 = b.cInvAddCode