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 |
|
harshad.pandhari@reportin
Starting Member
1 Post |
 Posted - 2009-01-30 : 08:00:12
|
| Hi, In One of my application, I am using one variable e.g. '1.Enter Name' and I want to use this same name as one of the prompts for my Stored Proc something like :DECLARE @1.Enter Name VARCHAR(50)So, anyone has any idea how can I declare such kind of variable inside a Stored Proc ? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-01-30 : 08:37:53
|
You can't make a stored procedure prompt for a value.The End.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
AvanthaSiriwardana
Yak Posting Veteran
78 Posts |
Posted - 2009-01-30 : 23:22:26
|
| You cant have that variable in SQL.Avantha SiriwardanaBeware of bugs in the above code; I have only proved it correct, not tried it. (Donald Knuth) |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-31 : 08:46:59
|
quote:
Originally posted by harshad.pandhari@reportin
Hi, In One of my application, I am using one variable e.g. '1.Enter Name' and I want to use this same name as one of the prompts for my Stored Proc something like :DECLARE @1.Enter Name VARCHAR(50)So, anyone has any idea how can I declare such kind of variable inside a Stored Proc ?
try @[1.Enter Name] |
|
|
|
|
|
|
Special Character in Stored Proc Prompt