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 vote193 views1 answer
Insert or update sql firebird
SQL
0 vote220 views1 answer
Sql query to select even numbers
SQL
0 vote195 views1 answer
Sql new line output
SQL
3 votes198 views1 answer
Oracle function return
SQL
0 vote280 views1 answer
SQL query to verify the size of the table
SQL
0 vote182 views1 answer
Sql datediff month
SQL
0 vote198 views1 answer
T sql dynamic top n query
SQL
0 vote190 views1 answer
Mysql default tls v1.3 ciphersuites
SQL
0 vote174 views1 answer
Oracle list proxy users
SQL
0 vote169 views1 answer
Mysql use password error
SQL