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 votes229 views4 answers
List databases in sql server
SQL
0 vote222 views2 answers
Update all linkedserver tables with openquery on db
SQL
0 vote236 views1 answer
Duplix print in Smartforms
SQL
12 votes214 views3 answers
Duplicate a column in sql
SQL
0 vote227 views1 answer
List column names of multiple tables psql
SQL
13 votes241 views2 answers
Sql online compiler
SQL
0 vote229 views1 answer
Contact mysql column field
SQL
0 vote255 views1 answer
Show specific events on mysql
SQL
0 vote238 views1 answer
What is between keyword used for
SQL
6 votes208 views1 answer
Oracle trigger after connect
SQL