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

2 votes183 views3 answers
Mysql pass command from command line
SQL
0 vote186 views1 answer
Sql query to delete row by id
SQL
2 votes194 views1 answer
Capitalize 1st letter in sql server
SQL
0 vote176 views1 answer
Psql select * from table
SQL
8 votes176 views1 answer
Unique vs primary key
SQL
0 vote189 views1 answer
Drop CHECK constraint sql
SQL
0 vote181 views1 answer
Mysql where don't have string
SQL
0 vote187 views2 answers
Connect to mysql server mac terminal
SQL
0 vote176 views1 answer
Mysql money value
SQL
21 votes203 views4 answers
Add column mssql
SQL