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

2 votes169 views2 answers
Mysql add hours to time field
SQL
0 vote160 views1 answer
How to find lowest in sql
SQL
0 vote168 views2 answers
Update query with between in mysql
SQL
7 votes160 views2 answers
Sql server drop temp table if exists
SQL
5 votes143 views1 answer
Sqlite alter table add column
SQL
0 vote145 views4 answers
Mysql on kubernetes
SQL
3 votes163 views1 answer
Oracle revoke
SQL
4 votes141 views1 answer
Create db table
SQL
1 vote166 views2 answers
Sql queries practice
SQL
0 vote186 views2 answers
Sql update multiple tables
SQL