Please support our MS SQL advertiser: Programming Forums
Views: 5873 | Replies: 1
 |
•
•
Join Date: Jun 2003
Location: Malaysia
Posts: 313
Reputation: 
Rep Power: 6
Solved Threads: 0
Posting Whiz
Can someone enlighten me on this issue ?
I have data source A - with a stored procedure in which I'd like to select records from tables in a different data source, B.
I have data source A - with a stored procedure in which I'd like to select records from tables in a different data source, B.
"Study the past if you would define the future" - Confucius
•
•
Join Date: Dec 2004
Posts: 8
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
if you would like to select records from a different database on the same server the syntax is
select ....
from [databasename].[owner].[table or view name]
if you would like to select records from a database on a different server first you will need to create a linked server entry, then the syntax is
select ....
from [servername].[databasename].[owner].[table or view name]
select ....
from [databasename].[owner].[table or view name]
if you would like to select records from a database on a different server first you will need to create a linked server entry, then the syntax is
select ....
from [servername].[databasename].[owner].[table or view name]
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
