-
How to select data between two SQL Servers???
Hello All!
This is my question.
I have two SQL Servers.
How do I perform the select query across two servers
for example If I have two databases on one server
I could do the following
Select * from tablename
where dbname1.dbo.tablename.columnname = dbname2.dbo.tablename.column.
How would I perform the above query if dbname1 is on Server1 and dbname2 is on server2?
Some one please help me.
Thanks
Venkat
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|