！！！奇怪的问题 OPENROWSET!!!

[maoliao]

select a.* from
OPENROWSET('SQLOLEDB','127.0.0.1';'sa';'futu7432',
'select * from fioa.dbo.syscolumns where id=object_id(''OA_FLOW_DEFINE'')')
as a
--没有返回任何行

select * from fioa.dbo.syscolumns where id=object_id('OA_FLOW_DEFINE')
--返回了17行

这是为什么？

[pbsql]

select a.* from
OPENROWSET('SQLOLEDB','127.0.0.1';'sa';'futu7432',
'select * from fioa.dbo.syscolumns where id=object_id(''fioa.dbo.OA_FLOW_DEFINE'')')
as a

[pbsql]

OA_FLOW_DEFINE 前要指定所在的数据库

[老宛]

--试试
select a.* from
OPENROWSET('SQLOLEDB','127.0.0.1';'sa';'futu7432',
'select * from fioa.dbo.syscolumns where id=object_id(''fioa..OA_FLOW_DEFINE'')')
as a

[子陌红尘]

因为没有取得对象的ID

select a.* from
OPENROWSET('SQLOLEDB','127.0.0.1';'sa';'futu7432',
'select object_id(''OA_FLOW_DEFINE'')')
as a

返回结果为NULL

[maoliao]

谢谢各位牛人