Tuesday, December 4, 2007

How do I pass Query to Linked Server

How do I pass Query to Linked Server

Step 1

To pass query to linked server, user can choose to use this command

SELECT * FROM jaguar.northwind.dbo.employees

Or

SELECT *

FROM OPENQUERY(jaguar, 'SELECT * FROM northwind.dbo.employees')

GO

in SQL Analyzers

Both of these command will return data results from a linked server called Jaguar.

No comments: