|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
|
|||
|
|||
|
Hi
help!!! I m using MSDE as a backend for my system, in which i have more then one database created depending upon the date i.e. I have distributed the database year wise. currently i have 5 databse created in MSDE. I m using VB as a front end tool. Problem : I have problem while fetching the data from MSDE. Client query is to retrieve certain data which spans more then 1 database. How can i fire a single query to get records from multiple databases? Is it possible for me to have single query to retrive the data or some other option? Thanking u Bhalchandra ![]() |
|
#2
|
|||
|
|||
|
Yes, I believe you can use a single query to get records from multiple databases. In your FROM clause you must explicitely specify your database like this:
dbname.dbowner.tablename |
|
#3
|
|||
|
|||
|
Thanx
Thanx for ur kind suggestion
Bhalchandra Mone ![]() |
![]() |
| Viewing: Dev Shed Forums > Databases > MS SQL Development > SQL Query |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|