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 vote265 views1 answer
Reset keys in sql
SQL
1 vote268 views2 answers
Changes not showing on website server odoo
SQL
0 vote259 views1 answer
Tsql cmd exec script from file
SQL
3 votes281 views1 answer
Only join in sql
SQL
0 vote271 views1 answer
Mysql workbench view
SQL
6 votes269 views1 answer
Wordpress change user password sql
SQL
4 votes298 views1 answer
Rename stored procedure in sql server
SQL
0 vote284 views1 answer
How to print sql query
SQL
0 vote266 views1 answer
How to get first 10 records of a table in mysql
SQL
0 vote281 views1 answer
How to find table lock and row lock in mysql
SQL