stored procedures - Coding Horror

database

Stored Procedures vs. Ad-Hoc SQL

In a recent article, Doug Reilly makes a fairly well reasoned case for the use of stored procedures in lieu of ad-hoc SQL: So, should you use SPs or ad-hoc SQL? The answer is "it depends." I have placed myself firmly on the side of doing all database

stored procedures

Who Needs Stored Procedures, Anyways?

It’s intended as sarcasm, but I believe this Daily WTF entry on Stored Procedures should be taken at face value: I’m sure we’ve all heard, over and over, that inline SQL is generally a bad practice, and that we should use Stored Procedures when possible. But let&