Posts
1150
Comments
891
Trackbacks
1
An old school way of writing application code

In this case, ‘old school’ means ‘generally bad’.

Now, in certain circles, one can’t swing a dead cat and not hit someone who thinks that stored procedures are evil.  Yawn, yawn, yawn.  No, they aren’t, get over it (having said that, you should rarely use them, as there is almost always a better way of doing things).

That being said, if you are going to write stored procedures, you almost definitely shouldn’t do them this way.  The mixing of insert/query/update code, the ’magic number’ error codes, the convoluted parameter checking, and this isn’t even an example that actually has any meaningful business logic (not at least as I define the term) whatsoever.

Don’t do this, please.

posted on Tuesday, November 18, 2014 12:20 PM Print
Comments
No comments posted yet.

Post Comment

Title *
Name *
Email
Url
Comment *  
Please add 2 and 6 and type the answer here: