var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: What do you prefix your stored procedures with?
I've seen the following
What do you guys use? Or is there any informal standard on this?
us sp_ as this is reserved for system stored procedures. NOT
In this crazy world on database development, consistency is the key.
Yeah I almost figured that too. Unfortunately, that's the one I like the best~!
So which do most people use?
Hmmm... never thought of that. I suppose that makes sense b/c in our C#/Java/etc. applications we never typically prefix anything either
I'm not sure where I got the idea that I had to prefix... Maybe just from sample code which typically have a habit of over-embellishing the standards/commenting part of coding.
I preface them with a project name, such as payroll_GiveRaise. There is no need to give them a prefix to tell you it's a stored procedure.
Ah yes - I'm not saying no naming convention. But a prefix that is on 100% of the objects of one type is not informative.
Usually I do something like:
Module is like your project. Entity maps to table. Action will be things like deletify, modificationalise, and get
Hmm, I see.
You do raise a good point about how prefixing 100% of your sprocs with the same prefix isn't informative at all.
I can't limit by project name either, because all these sprocs belong to the same project
Ack, maybe no prefix is the way to go for me
Then use pootle flump's module_entity_action without the module. But keep in mind that many small projects evolve into larger multi-project entities.
Yeah, good call there actually.
I'm currently using
Not for any particular reason tbh.... does make for some long names though.
Personally, if I have multiple projects using one database then I use schemas to separate them too, meaning that the qualified name for my objects become easier
No prefixes on sprocs.
No prefixes on tables.
No prefixes on views.
No prefixes on functions.
No prefixes on database names.
I name all of my stored procedures:
This_is_not_a_table_view_function_or_database_it_i s_a_sproc_called_ procname just in the hope that Blindman has to work on one of my databases ;-)
I use different naming conventions for different clients. Each has their own preference.
I worked in one shop for a long time (over 20 years) that had a preference that bordered on religioius dogma for a leading character and camel-case naming, so that habit tends to be ingrained, but I can and do switch from one convention to another as needed for each client.