Naming Conventions...

[jesus4u]

Can anyone direct me to some good sites that deal with organizing and naming not only variables but also how to design a good naming schema for forms, modules, COMs, StoredProcs?

Thanks

[peet]

try this : http://www.gui.com.au/html/coding_standards.htm

[Serge]

I personally don't like 1 letter prefixes. On that site variable naing convention is using single letter prefix except byte, float, single, double. object etc.

That's why I use 3 letter prefixes all the time.
For the scope that site uses g and m (global and module) which is the same thing I use. I also have a prefix p for the parameter.
So if you look at my code on this site you will see that I'm pretty consistent with the naming convention.

Good luck.

[jesus4u]

Serge, the problem I often run into is as the project develops I get backed into a corner with the naming of like my stored procs.

[MrGTI]

I have a brief listing of naming conventions on my webpage .

Basically, ..... use 1 letter for variables, and 3 for objects.

[Serge]

With stored procs I usually use lp_StoreProcName

lp indicates a local procedure.
The reason why I dont use "sp_" as many people do is because sp_ is being used by system stored procs.