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

7 votes132 views1 answer
Return insert results in POSTGRESQL
SQL
16 votes118 views3 answers
Delete row psql
SQL
1 vote118 views1 answer
Oracle stop job
SQL
0 vote117 views1 answer
Sql file in postgres with pgadmin
SQL
0 vote245 views2 answers
Illuminate\Database\QueryExceptionSQLSTATE[HY000] [2002] No such file or directory
SQL
0 vote125 views1 answer
Sql select all records from all tables where not empty
SQL
0 vote114 views1 answer
Automatically update database last seen datetime in sql
SQL
0 vote119 views1 answer
Mysql in clausule string array
SQL
0 vote120 views1 answer
Soql user profile
SQL
0 vote107 views1 answer
How to find unique key in sql
SQL