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 vote337 views1 answer
QCompleter con sql
SQL
0 vote271 views1 answer
Postgresql add leading zeros
SQL
1 vote322 views1 answer
Mysql batch insert
SQL
0 vote333 views1 answer
Select into table variable
SQL
1 vote340 views1 answer
Oracle create_program
SQL
0 vote361 views1 answer
Change permission to database mysql
SQL
61 votes529 views6 answers
Mysql add column
SQL
1 vote340 views1 answer
Where database run
SQL
2 votes363 views3 answers
Mysql kill
SQL
6 votes316 views1 answer
To count number of rows in SQL table
SQL