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 vote146 views1 answer
Write a query to peint the pattern P(20)
SQL
0 vote144 views1 answer
How to use sqlcommand
SQL
0 vote151 views1 answer
Flush user resource mysql
SQL
39 votes254 views5 answers
Sql drop column
SQL
0 vote162 views1 answer
Query to remove duplicate rows from a table
SQL
0 vote130 views1 answer
Inser into example
SQL
0 vote142 views1 answer
Failed to connect to localhost:1433 - self signed certificate
SQL
3 votes158 views1 answer
Select database in sql
SQL
2 votes144 views1 answer
Drop table if exists in postgres
SQL
0 vote171 views1 answer
"Hello User Name"
SQL