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

Source: stackoverflow.com

Similar codes

8 votes370 views1 answer
Check mysql version phpmyadmin
SQL
1 vote351 views2 answers
Changes not showing on website server odoo
SQL
0 vote360 views1 answer
Edit a field mysql terminal
SQL
0 vote361 views1 answer
Helptext in sql
SQL
0 vote674 views1 answer
How to connect .sql data set to powerbi
SQL
0 vote348 views1 answer
How to change the field size of an existing column
SQL
1 vote360 views1 answer
Postgres set sequence value to max id
SQL
0 vote376 views1 answer
Alter table change default
SQL
0 vote391 views1 answer
Sql values that contains certain multiple ids
SQL
0 vote372 views1 answer
Copy data from one postgres container to another
SQL