Sunday, August 24, 2008

OPENQUERY command and what all parameters you pass

OpenQuery Executes the specified pass-through query on the given linked server, which is an OLE DB data source
OPENQUERY ( linked_server , 'query' )
Example: EXEC sp_addlinkedserver 'OracleSvr', 'Oracle 7.3', 'MSDAORA', 'ORCLDB'
GO
SELECT * FROM OPENQUERY(OracleSvr, 'SELECT name, id FROM joe.titles')