RSS 2.0 Feed
RSS 2.0

Atom 1.0 Feed
Atom 1.0

  Stored Procs or Dynamic SQL 


So yesterday a debate surfaced that seemed to have the entire online programming community all worked up. Rob Howard, Microsoft ASP.NET Program Manager, posted to his blog about using stored procedures in SQL server. Many comments both for and against Rob's arguments in his post ensued. Things got a little heated when Frans Bouma stepped into the debate. Frans took his ideas to his own blog, and then you see the entire blogging community step in (via their own respective blogs) to add their own take on things. What a day.

Here's a break down of some of the more notable posts on both sides of the debate:

Rob Howard's original post (debate started in the post's comments):

Frans Bouma's counter:

Rob addresses Frans' arguments:

and then goes on some more:

The debate goes beyond just these posts from Rob and Frans. Doing some googles with lead you to many other places the debate surfaced. Although Frans does make some good arguments, I find that I side with Rob. I've always been deep in the stored proc camp. I love them. My arguments for why I like and use them is similar to what Donny Mack had to say about them (Edit: looks like that was actually Joseph Cooney). I use stored procs as an part of my data layer. Just as you might add methods to a class in the data layer, I have methods as procs. It gives me some abstraction from the database as I never again have to care where/how things go, I just pass them off. I develop for SQL server in almost every case. I'm not afraid of T-SQL. For me, stored procs are pure love. I can't imagine not using them.


Leave a comment below.


  1. Joe Smoe 2/5/2004 8:55 AM
    Wow ... limited mention of ObjectSpaces in this flame which, in my book, will nullify, deprecate and completely obselete this argument.

    With ObjectSpaces, dynamically generate all the SQL you want to your hearts content or write your u_sp's all day long ... i'll be building my application using the object persistence paradigm without having to boilerplate.
  2. Ryan Farley 2/5/2004 12:42 PM
    ObjectSpaces will be great. I look forward to using it also and will go that route in a heart-beat. But I am not sure how much it really applies to this arguement for the moment since it hasn't been released yet.
  3. arron 3/18/2005 5:19 AM
    can u tell u please when object spaces will be available
  4. 11/17/2005 3:25 AM
    please help me with the following codes.

    CREATE PROC PPP @SourceTable char(30)
    declare Name1=(select Name1 TableName from Tables where TableName=@SourceTable)
    select * from Name1

    it gives me error an message
  5. host 6/13/2007 11:34 AM
    I'd take stored procedures. i think its more straightforward.
  6. 9/19/2009 12:58 AM
    uxnajsjk - Google Search
Comments have been closed on this topic.



Also see my CRM Developer blog