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 vote176 views1 answer
Postgres data location
SQL
0 vote165 views1 answer
Mysqldump ignore table
SQL
1 vote181 views1 answer
Rename table column name in mysql
SQL
0 vote173 views1 answer
How to check xampp mysql password
SQL
17 votes182 views6 answers
MySQL ORDER BY
SQL
16 votes209 views1 answer
Sqlserver add column to table
SQL
0 vote188 views1 answer
Grant privileges of databse to user
SQL
0 vote174 views1 answer
Delete first row in sql
SQL
3 votes174 views1 answer
Oracle apex call duration
SQL
2 votes176 views1 answer
How to find table table in stored procedure sql server
SQL