select * from sys.servers
得到连接服务器名称 wswap\wssql然后执行 select * from openquery(wswap\wssql,'select * from spt_fallback_db)提示错误:Msg 102, Level 15, State 1, Line 2 '\' 附近有语法错误。问,咋回事?
得到连接服务器名称 wswap\wssql然后执行 select * from openquery(wswap\wssql,'select * from spt_fallback_db)提示错误:Msg 102, Level 15, State 1, Line 2 '\' 附近有语法错误。问,咋回事?
wswap是我的机器名字,wssql是数据库实例名称
系统自动整成这样的
参考:
(1)--/* dBase IV文件
select * from
OPENROWSET('MICROSOFT.JET.OLEDB.4.0'
,'dBase IV;HDR=NO;IMEX=2;DATABASE=C:\','select * from [客户资料4.dbf]')
--*/
(2)--/* dBase III文件
select * from
OPENROWSET('MICROSOFT.JET.OLEDB.4.0'
,'dBase III;HDR=NO;IMEX=2;DATABASE=C:\','select * from [客户资料3.dbf]')
--*/
(3)--/* FoxPro 数据库
select * from openrowset('MSDASQL',
'Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=c:\',
'select * from [aa.DBF]')
--*/
'Oracle 7.3',
'MSDAORA',
'ORCLDB'
GO
SELECT *
FROM OPENQUERY(OracleSvr, 'SELECT name, id FROM joe.titles')
GO