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

-1 vote317 views5 answers
Left join sql
SQL
0 vote315 views1 answer
How to get table current identity value in sql server
SQL
49 votes350 views6 answers
Install mysql ubuntu
SQL
4 votes185 views3 answers
Mysql update with join
SQL
2 votes263 views1 answer
How to check grants on a package in oracle
SQL
6 votes191 views1 answer
Wordpress change user password sql
SQL
0 vote239 views10 answers
Sql statement checker corrector
SQL
1 vote195 views1 answer
Mysql2::Error: Incorrect string value: '\xE2\x80\x8B
SQL
5 votes203 views3 answers
Postgres show databases
SQL
2 votes193 views3 answers
Current month mysql query
SQL