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 vote120 views1 answer
Postgresql linux password
SQL
1 vote107 views1 answer
Postgresql reset serial counter after deleting content
SQL
0 vote258 views1 answer
Hue hive UploadingTextFiletoHive
SQL
6 votes131 views2 answers
Clear a table in mysql
SQL
0 vote117 views2 answers
How to drop mili second in sql
SQL
0 vote100 views1 answer
Pgadmin see indexes
SQL
5 votes104 views1 answer
Sysdate in oracle sql
SQL
1 vote96 views2 answers
T sql get foreign key
SQL
14 votes124 views4 answers
Online sql compiler
SQL
3 votes101 views1 answer
Sql multiple column index
SQL