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 vote169 views1 answer
Oracle create table auto generated primary key
SQL
0 vote185 views1 answer
Sql comand for removing data from table
SQL
0 vote129 views1 answer
Get last run query sql server
SQL
21 votes183 views4 answers
Oracle add column
SQL
1 vote181 views1 answer
Mysql return if it contains
SQL
0 vote170 views1 answer
Sql period overlap
SQL
1 vote234 views1 answer
How to put value in variable mysql
SQL
0 vote174 views1 answer
Tsql cmd exec script from file
SQL
1 vote380 views1 answer
Foreign key in oracle sql developer
SQL
8 votes210 views1 answer
See all users mysql
SQL