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

2 votes241 views2 answers
Postgres change owner of schema
SQL
0 vote245 views1 answer
Grouping by email domain mysql
SQL
0 vote197 views1 answer
Mysql export and import
SQL
2 votes192 views1 answer
Plsql block
SQL
5 votes418 views2 answers
How to ascending order in sql
SQL
0 vote201 views1 answer
Mysql select last 15 minutes
SQL
0 vote190 views1 answer
Find how many table doesn't contain column in mysql
SQL
1 vote209 views1 answer
Oracle enable job
SQL
0 vote202 views2 answers
#1273 - Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
0 vote218 views1 answer
Sql revert migration
SQL