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

0 vote172 views2 answers
Mysql dump database tables only
SQL
0 vote174 views1 answer
Mysql terminal run sql file
SQL
1 vote210 views1 answer
Oracle grant select on schema
SQL
0 vote195 views1 answer
Replace \n sql
SQL
10 votes202 views4 answers
Mysql one week ago
SQL
0 vote162 views1 answer
What is between operator
SQL
2 votes161 views1 answer
Oracle index size calculation
SQL
0 vote127 views1 answer
Plsql trigger insert update
SQL
0 vote157 views1 answer
LoadError: cannot load such file -- mysql2/2.7/mysql2
SQL
0 vote192 views1 answer
Mysql concatenate select results
SQL