Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-04-04 : 07:57:21
|
| HARSH writes "I WANT TO CREAT A DATABASE, WHICH HAS A FIELD AS DATABASE NAME. WHERE I WILL GIVE THE DATABASE NAME, WHICH IS LINKED THRU A FRONT END. NOW TRU MY CREATED DATA BASE I WANT TO ACCESS OTHER(DEFINED IN DATABASE NAME FIELD) DATABASE TABLES AND THERE VALUES WHICH I CAN USE TO IMPLEMENT MY LOGIC. HOW TO ACCESS OTHER DATA BASE TABLES IN MY FRONT END AND RESPECTIVE BACK END.IAM USING SQL SERVER AND VB. HOPE FULLY U R UNDERSTANDING MY QUERY. PLEASE DO RESPOND AND TELL ME WHERE I CAN FIND ITS SOLUTION." |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2005-04-04 : 08:02:44
|
| You can access other databases by using [databasename].[objectowner].[object] syntax in your queries, but you would need to use dynamic SQL to substitute a parameter for the database name if you wanted to do this on the fly. It's probably a better idea to rethink your application design to avoid doing this.Also, you can turn off the capital letters with the "CAPS LOCK" key.-------Moo. :) |
 |
|
|
|
|
|
LINKING TWO OR MORE DATABASE