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

1 vote290 views1 answer
Mysql pretty date format
SQL
0 vote294 views1 answer
Create new table pl sql
SQL
0 vote312 views1 answer
Str_to_date sql server
SQL
16 votes307 views2 answers
Add column to all tables after first column mysql
SQL
12 votes316 views3 answers
Install sqlite driver ubuntu
SQL
17 votes293 views6 answers
Mysql import sql file
SQL
0 vote296 views1 answer
Sub query in linq
SQL
0 vote351 views1 answer
Mysql relationships between tables
SQL
0 vote335 views1 answer
Mysql reset wp_options
SQL
0 vote323 views1 answer
Primary key multiple colums
SQL