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 vote450 views1 answer
Compress sql file database ubuntu
SQL
16 votes382 views1 answer
Mysql reset auto increment value
SQL
2 votes417 views3 answers
How to replace null values in sql
SQL
1 vote355 views1 answer
Show table status command in mysql
SQL
0 vote326 views10 answers
John the ripper mysql
SQL
0 vote355 views1 answer
How to fetch unique records from two tables
SQL
0 vote347 views1 answer
Mssql current date
SQL
0 vote372 views1 answer
Https://livesql.oracle.com/apex/livesql/s/l8fedwph53gt5gigbacwvu6m0
SQL
0 vote353 views1 answer
Sql how to display two atributes as one in sql
SQL
0 vote366 views1 answer
EnvironmentError: mysql_config not found
SQL