Retrieve Data From Tables Stored in Different Database

Question

I want to know how to retrieve data from tables stored in different database in SQL Server. Thank you.

Vilas Gite · Answer

Hi Vipendra There are two database STUDENT & TRAIL SELECT * FROM [STUDENT].[dbo].[student_detail] tab1 INNER JOIN [trail].[dbo].[tbl1] tab2 ON tab1.roll_no = tab2.roll_no

Vilas Gite · Answer

Hi Vipendra Go through http://stackoverflow.com/questions/5145637/querying-data-by-joining-two-tables-in-two-database-on-different-servers