|
Site Sponsored By: SQLDSC - SQL Server Desired State Configuration
|
|
|
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.
|
- Advertisement - |
How to use declared variable in USE statement ?
Posted - 2008-12-16 : 05:22:37
-- Do you have a solution for this? -- The scenario goes something like this.. Declare @dbName nvarchar(100) Set @dbName = 'SampleDatabase' Print 'The database is : ' + @dbName-- Then output will be.. The database is : SampleDatabase-- In this part, it was succesfully executed.-- But when we try to use the variable @dbName this way... Declare @dbName nvarchar(100) Set @dbName = 'SampleDatabase' Use @dbName <<--- the error is in here-- Error message appears.. Incorrect syntax near '@dbName'.-- How can we run Use @dbName as though we are-- using Use SampleDatabase ?-- Thanks very much in advance!! 