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 vote113 views1 answer
Error code 1292 mysql workbench
SQL
0 vote110 views1 answer
Dataframe lambda elif
SQL
17 votes122 views5 answers
Order by sql
SQL
1 vote111 views1 answer
Sqlserver create table from select
SQL
1 vote113 views1 answer
How to use db.execute
SQL
1 vote122 views1 answer
Postgres power
SQL
0 vote115 views1 answer
Alter table change default
SQL
2 votes143 views1 answer
Oracle log files
SQL
2 votes119 views3 answers
How do I add a user to a postgres database? cli
SQL
0 vote89 views1 answer
Knex last insert id mysql
SQL