Answers for "how to select data from two database in sql"

SQL
0

how to get data from 2 database

-- Fetch data from the other database server
SELECT *
INTO #myTempTable
FROM OPENQUERY([DB2], 'SELECT * FROM [MyDatabaseOnDB2].[dbo].[MyOtherTable]')

-- Now I can join my temp table to see the data
SELECT * FROM [MyDatabaseOnDB1].[dbo].[MyTable] tab1
    INNER JOIN #myTempTable tab2 ON tab1.ID = tab2.ID
Posted by: Guest on June-16-2020

Code answers related to "how to select data from two database in sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language