We're a community of 1077K IT Pros here for help, advice, solutions, professional growth and fun. Join us!
1,076,280 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Start New Discussion Reply to this Discussion

Select records from different data source

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.

2
Contributors
1
Reply
5 Hours
Discussion Span
7 Years Ago
Last Updated
2
Views
red_evolve
Posting Whiz
313 posts since Jun 2003
Reputation Points: 53
Solved Threads: 1
Skill Endorsements: 0

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]

sifuhall
Newbie Poster
13 posts since Dec 2004
Reputation Points: 10
Solved Threads: 0
Skill Endorsements: 0

This article has been dead for over three months: Start a new discussion instead

Post: Markdown Syntax: Formatting Help
 
You
 
© 2013 DaniWeb® LLC
Page rendered in 0.0541 seconds using 2.64MB