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

1 vote344 views1 answer
Oracle schema size
SQL
0 vote346 views1 answer
MySql shutdown unexpectedly InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Uses event mutexes
SQL
1 vote345 views1 answer
Mysql return text after a final full stop
SQL
0 vote321 views1 answer
How to return only the Date from a SQL Server DateTime datatype
SQL
0 vote355 views2 answers
Faster mysql imports
SQL
0 vote401 views1 answer
Com.mysql.cj.exceptions.InvalidConnectionAttributeException more than one time zone. You must configure either the server or JD value if you want to utilize time zone support.
SQL
3 votes348 views2 answers
Create schema postgres
SQL
0 vote336 views1 answer
Oracle string substitution
SQL
38 votes384 views6 answers
Alter table mysql
SQL
1 vote352 views1 answer
Spark sql concatenate string and int
SQL