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

19 votes141 views4 answers
Rename database in sql
SQL
0 vote153 views1 answer
Install squirrel sql ubuntu
SQL
0 vote135 views1 answer
Oracle search columns in schema
SQL
0 vote149 views2 answers
Py sqlite if entry exists
SQL
-1 vote178 views2 answers
Sql search all tables for attributes
SQL
2 votes156 views2 answers
Mysql on duplicate key update get value from values
SQL
7 votes148 views2 answers
Execute mysql file
SQL
0 vote161 views1 answer
No suitable driver found for sqlite
SQL
0 vote180 views1 answer
Bash block size ls /var/lib/mysql
SQL
0 vote140 views1 answer
Select in select sql
SQL