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

3 votes298 views1 answer
Sql select all
SQL
8 votes327 views1 answer
Oracle create datafile
SQL
2 votes298 views1 answer
How to select first row of database sql
SQL
0 vote312 views1 answer
Mysql group by range
SQL
1 vote317 views1 answer
Multiple count in sql
SQL
0 vote294 views1 answer
Html css mobile menu arrow dropdown
SQL
0 vote330 views2 answers
CREATE OR REPLACE FUNCTION
SQL
1 vote368 views1 answer
Oracle drop temporary table
SQL
0 vote305 views2 answers
Mysql updating multiple column values from array variable
SQL
0 vote330 views1 answer
Https://livesql.oracle.com/apex/livesql/s/l8fedwph53gt5gigbacwvu6m0
SQL