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 vote139 views1 answer
Display first three characters sql
SQL
0 vote135 views1 answer
How to fix mysql stop unexpectedly
SQL
10 votes133 views4 answers
How to alter table name in mysql
SQL
-1 vote136 views1 answer
Sql add column bit
SQL
0 vote147 views1 answer
Oracle sql drop table
SQL
0 vote139 views1 answer
How much table store postgres
SQL
0 vote156 views1 answer
"Hello User Name"
SQL
0 vote139 views5 answers
Mode sql course
SQL
1 vote136 views1 answer
Oracle rolling back transactions
SQL
0 vote133 views1 answer
What is ssrs and ssis in sql server
SQL