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 vote267 views2 answers
Update all linkedserver tables with openquery on db
SQL
1 vote277 views1 answer
How to use a trigger to validate input data
SQL
3 votes280 views2 answers
How to modify rows in SQL Server
SQL
16 votes294 views3 answers
Update table from another table
SQL
1 vote277 views1 answer
Sql eliminare un record
SQL
0 vote266 views1 answer
Oracle get running queries
SQL
1 vote247 views1 answer
Stored procedure return value
SQL
0 vote272 views1 answer
Online sql testing tool
SQL
0 vote284 views1 answer
How to combine first and last nae into one columb sql
SQL
2 votes294 views1 answer
Search query in mysql
SQL