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 vote272 views1 answer
Sql add calculated column
SQL
1 vote295 views1 answer
Mysql count all table rows
SQL
0 vote266 views1 answer
How to connect postgresql database with java
SQL
0 vote271 views1 answer
Min mysql
SQL
0 vote284 views1 answer
Print hello world in plsql
SQL
0 vote286 views1 answer
Remove binlog mysql
SQL
0 vote267 views1 answer
Setval postgres example table id
SQL
1 vote301 views1 answer
Tsql replace value in json
SQL
0 vote269 views3 answers
Sql all columns
SQL
2 votes267 views3 answers
Mysql list tables by size
SQL