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 vote204 views1 answer
Postgres grep entire database
SQL
1 vote176 views1 answer
Sql delete row with auto increment
SQL
0 vote214 views1 answer
Hallo
SQL
1 vote248 views1 answer
Is sql fast
SQL
0 vote241 views1 answer
Postgresql remove new line from string
SQL
0 vote204 views3 answers
Sql query checker
SQL
0 vote272 views1 answer
Sql delete row from table where id
SQL
0 vote195 views1 answer
Sql shell psql cannot enter password
SQL
-2 votes198 views2 answers
Union vs union all in sql
SQL
1 vote196 views2 answers
Postgres cast as decimal
SQL