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

6 votes130 views1 answer
How to count number of rows in sql
SQL
14 votes131 views2 answers
Oracle export trigger ddl
SQL
0 vote124 views1 answer
MySql Modify Increment
SQL
0 vote127 views1 answer
MySQL error code 2068
SQL
0 vote129 views1 answer
Sql remove last 2 digit
SQL
0 vote131 views1 answer
Mysql beautifier terminla
SQL
0 vote133 views2 answers
Uninstall postgresql mac
SQL
1 vote121 views1 answer
Mysql login console
SQL
0 vote124 views2 answers
Zsh: command not found: mysq
SQL
62 votes169 views8 answers
Mysql add column
SQL