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 vote339 views1 answer
Postgres delete from where date is greater than specific date
SQL
0 vote327 views1 answer
Mysql:5.6 syntax create table
SQL
0 vote344 views2 answers
MySQL top percent
SQL
0 vote324 views1 answer
Http://challenge01.root-me.org:58036/wsasd
SQL
0 vote324 views1 answer
MySql count occurences more than"
SQL
1 vote447 views2 answers
Begin transaction sql
SQL
0 vote345 views1 answer
Having trouble running COUNT in my INSERT INTO statement
SQL
0 vote346 views2 answers
SQL Server log file truncate - Source :NAYCode.com
SQL
0 vote324 views0 answer
SQL
1 vote354 views1 answer
SQL date part only of datetime
SQL