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 vote203 views1 answer
Check message id sql server
SQL
3 votes236 views1 answer
Sql online test questions and answers
SQL
0 vote219 views4 answers
Mysql count table rows
SQL
5 votes231 views2 answers
Mysqldump password
SQL
0 vote229 views1 answer
How we can perform acid Operations in sql with examples
SQL
0 vote221 views1 answer
Postgres reorder columns
SQL
0 vote204 views1 answer
Eliminar ultimo carcacter mysql
SQL
0 vote212 views1 answer
Use where instead of join
SQL
3 votes196 views1 answer
Sql replace character in string in all records
SQL
4 votes209 views1 answer
Wilayah indonesia sql
SQL