Describe how OPENQUERY function is used to excess external data.
OPENQUERY is used to execute the specified query on the linked sever.
OPENQUERY can be referenced in from the FROM clause just like a table name.
Syntax:OPENQUERY ( linked_server ,'query' )
OPENQUERY does not accept variables for its arguments.
Example:SELECT * FROM OPENQUERY (OracleSvr, 'SELECT name, id FROM joe.titles')
