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 vote366 views1 answer
How to check foreign key constraint in sql
SQL
1 vote251 views1 answer
Flask-sqlalchemy filter_by contains
SQL
0 vote305 views1 answer
Restore backup mysql .gz
SQL
1 vote252 views1 answer
Alter user mysql native password
SQL
0 vote311 views1 answer
Influxdb clone measurement
SQL
0 vote286 views1 answer
Sql server udf performance
SQL
0 vote297 views1 answer
Opening xampp mysql in cmd ubuntu
SQL
5 votes307 views2 answers
Mysql create database charset utf8mb4
SQL
0 vote286 views1 answer
Join in update query in mysql
SQL
0 vote283 views1 answer
Oracle last character of string
SQL