SELECT Statement

[Vic]

I would like to select data from another server. What is the syntax??
Eg.
Select * from database1..table1
Where should I put the server name??


Thanks in advance!

[Jim W]

Assuming you have created the linked server, use this:

select * from otherserver.database1..table1


------------
Vic at 3/7/01 10:16:23 AM

I would like to select data from another server. What is the syntax??
Eg.
Select * from database1..table1
Where should I put the server name??


Thanks in advance!

[Vic]

how do I create the linked server??


------------
Jim W at 3/7/01 10:19:01 AM

Assuming you have created the linked server, use this:

select * from otherserver.database1..table1


------------
Vic at 3/7/01 10:16:23 AM

I would like to select data from another server. What is the syntax??
Eg.
Select * from database1..table1
Where should I put the server name??


Thanks in advance!

[phil_mccormack]

look up sp_addlinkedserevr in books online.


------------
Vic at 3/7/01 10:22:15 AM

how do I create the linked server??


------------
Jim W at 3/7/01 10:19:01 AM

Assuming you have created the linked server, use this:

select * from otherserver.database1..table1


------------
Vic at 3/7/01 10:16:23 AM

I would like to select data from another server. What is the syntax??
Eg.
Select * from database1..table1
Where should I put the server name??


Thanks in advance!