944,103 Members | Top Members by Rank

Ad:
  • MS SQL Discussion Thread
  • Unsolved
  • Views: 19657
  • MS SQL RSS
Jul 21st, 2005
0

Select records from different data source

Expand Post »
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.
Reputation Points: 53
Solved Threads: 1
Posting Whiz
red_evolve is offline Offline
313 posts
since Jun 2003
Jul 21st, 2005
0

Re: Select records from different data source

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]
Reputation Points: 10
Solved Threads: 0
Newbie Poster
sifuhall is offline Offline
13 posts
since Dec 2004

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MS SQL Forum Timeline: tricky SQL query
Next Thread in MS SQL Forum Timeline: How do I calculate ages





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC