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 vote129 views1 answer
Sum sqlserver
SQL
4 votes133 views3 answers
Employee name starting with in sql
SQL
0 vote179 views1 answer
Postgres list all stored procedures query
SQL
0 vote139 views1 answer
How to get one year old query from plan cache
SQL
0 vote136 views1 answer
Mysql cast null to string
SQL
0 vote159 views1 answer
Isnull in sqlite
SQL
12 votes137 views4 answers
Psql command not found
SQL
0 vote132 views1 answer
Match end of string regex sql
SQL
0 vote124 views1 answer
Change permission to database mysql
SQL
0 vote120 views1 answer
Mysql case when on date
SQL