how to get data from 2 database

Solutions on MaxInterview for how to get data from 2 database by the best coders in the world

Search
showing results for - "how to get data from 2 database"
Janie
27 Jun 2016
1-- Fetch data from the other database server
2SELECT *
3INTO #myTempTable
4FROM OPENQUERY([DB2], 'SELECT * FROM [MyDatabaseOnDB2].[dbo].[MyOtherTable]')
5
6-- Now I can join my temp table to see the data
7SELECT * FROM [MyDatabaseOnDB1].[dbo].[MyTable] tab1
8    INNER JOIN #myTempTable tab2 ON tab1.ID = tab2.ID
source
similar questions
mysql select another databasesql 7c select data from multiple tableshow to fetch data from database without last columncopy data from one database to anothersql select data from one database and insert into a different databasec 23 mysql data reader from two tablesdifference berween database and data base management systemget all db sizes in mysql servermariadb select multiple rows into one columnget from database the most recent data limit by 5how to retrieve data from multiple tables in sqleloquest how to select one specific column in databasehow to fetch data from database in sqlhow to select specific table data from an mysql databse server 3ahow to retrieve data from a sql server database in c 23
queries leading to this page
making two database queriessql multiple databases queryquery to retrieve data from multiple databases on different serversselect statement mssql across databasescan 27t query multiple databases sql serverhow to query different database at the same timeselect multiple databasesquery two databases mysqlmultiple query for multiple databasescan i select two databases on a single filesql server query with 2 databaseshow to connect two database in sql queryselect multi databasejoin two databases in sqlhow to get data from 2 databaseselect from two databases sqlsql server select from multiple databasesif two databases are on different host how to write joinshow to select data from two database in sqlhow to find data from different databasequery multiple databases in sql serverhow to query multiple databaseshow to select multiple databaser tablecross query multiple different kinds of databasesselect multiple databases name how to return data from 2 databaseshow do you have multiple query in databaseshow to get data from 2 database