December 13, 2012 at 4:29 am
hi,
In my work environment i have faced problem with getting data from two different sql servers like below
server A(ip:1.1.1.1) server B(1.1.1.2)
Database A Database B
Table A Table B
what i need to inner join table A and Table B..can any one suggest on this it would be greate help to me.
Thanks,
Dastagiri
December 13, 2012 at 6:04 am
Are you able to setup linked servers?
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
December 13, 2012 at 6:29 am
http://www.sqlservercentral.com/Forums/Topic938337-149-1.aspx
Malleswarareddy
I.T.Analyst
MCITP(70-451)
December 13, 2012 at 10:22 am
This assumes you have successfully set up and are able to use a linked server: SELECT
a.col1,
b.col1
FROM
LinkedServerA.DatabaseA.dbo.TableA
INNER JOIN LinkedServerB.DatabaseB.dbo.TableB
ON a.col1 = b.col1
WHERE
a.somecondition = 'something that makes sense'
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply