select * from
openrowset('SQLOLEDB'
, 'server';'SA';'pwd'
,' SET NOCOUNT ON
SET FMTONLY ON
exec lsdata..dsWipCKMatUse ''2005/08/01'' , ''2005/08/30'' , 50
'
)
openrowset('SQLOLEDB'
, 'server';'SA';'pwd'
,' SET NOCOUNT ON
SET FMTONLY ON
exec lsdata..dsWipCKMatUse ''2005/08/01'' , ''2005/08/30'' , 50
'
)
openrowset('SQLOLEDB'
, 'server';'SA';'pwd'
,' SET NOCOUNT ON
exec lsdata..dsWipCKMatUse ''2005/08/01'' , ''2005/08/30'' , 50
'
)
SELECT *
FROM OPENDATASOURCE(
'SQLOLEDB',
'Data Source=192.168.0.2;User ID=sa;Password=XXXXXXX'
).fx.dbo.usertable where 你的条件这是我要访问服务器为192.168.0.2的fx库的usertable表的内容
Could not process object 'set NOCOUNT ON SET ANSI_NULLS ON exec lsdata..TestProc SET NOCOUNT OFF'. The OLE DB provider 'SQLOLEDB' indicates that the object has no columns.
把#临时表改为正常表的话就没问题,这是怎么回事,难道还有这样的限制???
楼上的也可以测一下--執行不成功
crate proc proc1
as
select * into #temp from sysobjects
select * from #temp
go--成功執行
crate proc proc1
as
select * from sysobjectsgo
create proc proc1
as
select * into #temp from sysobjects
select * from #temp
go--测试
select * from
openrowset('SQLOLEDB'
, 'FUDAN-OXI9Y1PYT';'SA';'123456'
,' SET NOCOUNT ON
SET FMTONLY Off
exec test..proc1
'
)