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

2 votes157 views3 answers
Sql server reseed identity column
SQL
244 votes255 views14 answers
Sql n insert
SQL
0 vote141 views1 answer
Aktor yang pernah terlibat di film bergenre Aksi di sql
SQL
0 vote133 views2 answers
Sql day from datetime
SQL
1 vote136 views1 answer
Mysql show data from table
SQL
0 vote198 views1 answer
Sqlite display headers on columns
SQL
13 votes180 views6 answers
Mysql remove duplicates
SQL
0 vote131 views1 answer
Sql select most frequent value in group
SQL
1 vote136 views1 answer
Oracle list data files
SQL
1 vote141 views1 answer
Alter add syntax
SQL