Friday, March 30, 2012

query 2 server at the same time

can some one please tell me with an example,how to query data from two db server in the same tsql query.

Thanks in advace

You have to setup a linked server and then use full 4 parts to query the linked server.

SELECT *
FROM linkserver.dbname.schema.tablename
JOIN tablename

No comments:

Post a Comment