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 vote148 views1 answer
Mssql disable foreign key constraint
SQL
0 vote141 views1 answer
Flush user resource mysql
SQL
0 vote134 views1 answer
ORACLE SUBSTRING SYNTAX
SQL
1 vote149 views1 answer
Median mysql
SQL
0 vote145 views1 answer
Sql find gaps in date ranges
SQL
2 votes183 views1 answer
Remove foreign key constraints in postgres
SQL
24 votes141 views6 answers
Sql change table name
SQL
0 vote146 views4 answers
Sql rownum
SQL
3 votes136 views2 answers
Sql add year to date
SQL
0 vote134 views1 answer
Sql gap missing values
SQL