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

1 vote242 views1 answer
Create sample data postgresql
SQL
-1 vote257 views3 answers
SQL to LINQ converter
SQL
1 vote267 views1 answer
Too many connections mysql
SQL
0 vote258 views1 answer
Guid string to binary better
SQL
7 votes263 views6 answers
Group_concat in mysql
SQL
-1 vote269 views1 answer
Get month and year from date in mysql sequelize
SQL
0 vote246 views1 answer
Oracle archivemode
SQL
1 vote246 views1 answer
Oracle update with sequence
SQL
0 vote265 views1 answer
Sql find record cannot cast date
SQL
0 vote246 views7 answers
10 random questions use python and SQL
SQL