MS SQL

MS SQL RSS

Select records from different data source

Please support our MS SQL advertiser: Intel Parallel Studio Home

•

Join Date: Jun 2003

Posts: 313

Reputation: red_evolve is on a distinguished road

Solved Threads: 0

red_evolve red_evolve is offline

Offline

Posting Whiz

Select records from different data source

Jul 21st, 2005

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.

"Study the past if you would define the future" - Confucius

•

Join Date: Dec 2004

Posts: 8

Reputation: sifuhall is an unknown quantity at this point

Solved Threads: 0

sifuhall

Offline

Newbie Poster

Re: Select records from different data source

Jul 21st, 2005

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]