Answer: One sql server is added to another sql server, this concept is called linked server. Linked server is used to extract query from different sql server.
Example:
select tab1.* from dbserver1.db1.dbo.table1 tab1,
dbserver1.db2.dbo.table2 tab2
where tab1.id=tab2.id
Asked In: Many Interviews |
Alert Moderator