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

9 votes311 views3 answers
Mysql run sql file
SQL
0 vote336 views1 answer
Sql datum formatieren
SQL
0 vote228 views1 answer
Sqlalchemy existing database
SQL
0 vote308 views3 answers
Run sql command line
SQL
0 vote320 views1 answer
Pgadmin save data greyed out
SQL
1 vote304 views1 answer
Change default maximum runtime mariadb from phpmyadmin
SQL
4 votes276 views1 answer
Restart for pg_hba.conf file
SQL
0 vote281 views1 answer
How to use lower case in mysql
SQL
0 vote270 views1 answer
Pl sql search saurce code
SQL
0 vote281 views2 answers
How to find sql server agent jobs related to a database
SQL