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 vote196 views1 answer
Login phpmyadmin without password
SQL
1 vote198 views1 answer
Create temporal table in sql
SQL
1 vote215 views1 answer
Sql server loop over query
SQL
0 vote200 views1 answer
Oracle sql get value from several rows and concatenate strings
SQL
0 vote226 views1 answer
Postgresql print sessions using the database
SQL
5 votes214 views3 answers
Sql server utc to local
SQL
1 vote191 views1 answer
How to open closed port mysql in ubuntu
SQL
3 votes208 views2 answers
Postgresql remove not null constraint
SQL
1 vote199 views1 answer
Mysql show current queries
SQL
0 vote202 views1 answer
How to print records of employees hired in particular month in oracle
SQL