April 18, 2013 at 11:22 pm
Hi Friends,
i had a requirement , which leads to work on two database on two different data servers. Now my Problem is how to connect one database to another database.
i have to access the other database procedures and other operation like CRUD .
Please give me some examples or Idea to approach
Thanks in Advance
April 19, 2013 at 12:54 am
Hi,
Firstly, you need to link the servers, after that it is fairly straight forwards:-
select * from database.schema.table1
inner join server.database.schema.table2
on . . . . . .
You only need to specify the server for the linked server - the above, very rough example means that table1 is on the local server
Hope this helps
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply