顶
我设置链接服务器不能成功,不知为何?
EXEC sp_addlinkedserver
@server = 'LONDON',
@srvproduct = 'Oracle',
@provider = 'MSDAORA',
@datasrc = 'orcl'
GO
sp_addlinkedsrvlogin'LONDON',
false,
'sa',
'system',
'czw'
go
SELECT *
FROM OPENQUERY(LONDON, 'SELECT * FROM tab')
GO
|