|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Connecting to a database via variable
I am currently trying to create a table in a database via a stored procedure. The db name has been passed as a variable from a .net page.
If i use a create table statement with the variable name followed by the table name, it tries to look for the variable name as the database, instead of the value. Unfortunately you cant use a USE statement in a stored procedure to call the DB. Any ideas? |
|
#2
|
||||
|
||||
|
In order to create a table you have to also create a field with it.
|
![]() |
| Viewing: ASP Free Forums > Database > SQL Development > Connecting to a database via variable |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|