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 |
|
SexyChick
Starting Member
6 Posts |
 Posted - 2010-05-04 : 15:42:30
|
| I recently come across a sproc where the parameter name was shared with a local variable name. They were of the same datatype as well. How would you be able to determine between the 2 which is which? An example is below:ALTER Procedure [dbo].[usp_Toolkit_Synch_Clinic] @Clinic_ID as bigint AsDeclare @ClinicID as bigint... |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
SexyChick
Starting Member
6 Posts |
Posted - 2010-05-04 : 15:53:43
|
| oops, my mistake. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-05-07 : 09:34:02
|
quote:
Originally posted by SexyChick
I recently come across a sproc where the parameter name was shared with a local variable name. They were of the same datatype as well. How would you be able to determine between the 2 which is which? An example is below:ALTER Procedure [dbo].[usp_Toolkit_Synch_Clinic] @Clinic_ID as bigint AsDeclare @ClinicID as bigint...
Note that you can't declare two variables with same nameSo there is strong reason that variable names are differentMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Parameter Names and Variable names in sprocs
Tara Kizer