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 vote331 views1 answer
Is there a way to use read_sql_query and the query has WHERE column = Variable?
SQL
0 vote340 views1 answer
Search In the Database using Text
SQL
0 vote316 views1 answer
Original Query
SQL
5 votes314 views2 answers
Oracle show procedures
SQL
0 vote336 views1 answer
SAP Return
SQL
3 votes325 views2 answers
How to modify rows in SQL Server
SQL
3 votes327 views1 answer
Force using index plsql
SQL
0 vote306 views1 answer
How to reset AI in sql
SQL
-1 vote332 views4 answers
Restart mysql server ubuntu
SQL
2 votes325 views1 answer
Add new column not null sql server
SQL