vijay reddy

vijay reddy

  • NA
  • 13
  • 4.1k

Linked Server concept

Jun 19 2016 12:34 PM
Hi,
 
I have two sql databases in different servers, now one database is displaying information to the users in front end and i have to display data to the users by using two different servers database by using one database view.  i know how to link the database.
 
how can i present the data to the customer by using linked server concept.
 
Ex:
1)EMP table is having firs database in first server
2)Dept table and view having second database in second server
3)by using second database view, how can i present both EMP and Dept tables information into one output.
 
 
Please help me on this issue. 
 
 
.  

Answers (3)