Breaking News: Grepper is joining You.com. Read the official announcement!

how to get data from 2 database

Super Serval answered on June 16, 2020 Popularity 7/10 Helpfulness 1/10

answer how to get data from 2 database

how to get data from 2 database

Comment

-- 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

Popularity 7/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: database get sql

Link to this answer
Share Copy Link