OPENQUERY:
Executes the specified pass-through query on the specified linked server.
OPENQUERY ( linked_server ,'query' )
OPENQUERY can also be referenced as the target table of an INSERT, UPDATE, or DELETE statement.
http://msdn.microsoft.com/en-us/library/ms188427.aspx
OPENQUERY can be a target of select query, like:
SELECT ..... FROM OPENQUERY ( linked_server ,'query' )
OPENQUERY can be a target of select query, like:
SELECT ..... FROM OPENQUERY ( linked_server ,'query' )
No comments:
Post a Comment