Jeff Moden (9/23/2008)
Heh... include my post in your report on usage potential advising against using it.The only time I even come close to Hungarian notation is that I'll use a "pi" or "po" prefix on parameters in long stored procedures just to make the parameters easier to identify on long procs.... but I darned sure won't prefix one with something like "i" or "int" because even variables and parameters can change requirements of time. Imagine having a bunch of GUI or T-SQL that passes named parameters to a proc and ultimately ending up thinking something was other than an Int because even though the data type for the variable changed, you couldn't change the name of the parameter for fear of breaking GUI code that did use named parameters.
I put "_in" on the end of input parameters, "_out" on the end of output parameters, and "_inout" on bidirectional parameters. That's at the end of the name. Makes it very easy to tell, hundreds of lines into a complex proc, which things are parameters and which are locally declared variables.
The data type is too easy to end up having to change, like you say, so I don't include that. Just the direction. I've found it very useful.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon