Geeks With Blogs

Scott Kuhl Warning: I may have no idea what I am talking about!

The stored procedures vs. dynamic SQL battle rages on with yet another article.  Douglas Reilly covers:

  • Security: No SP advantage, unless restricting access to rows in complex ways.
  • Performance: Some SP advantage when complex operations are involved.
  • Maintenance: For me, SPs have a slight edge in convenience.
  • The cross-platform tie-in argument

Each project chooses its approach for various reasons, some correct, some not.  On one project I worked on we were forced to use dynamic SQL because the DBAs had the development server so locked down, we could not write stored procs effectively.  We had to have an “approved” DBA do the work which would often take weeks for a single stored procedure.

So just like there is no single right answer in .NET vs Java, there is no single right answer in stored procedures vs. dynamic SQL.

Posted on Wednesday, August 31, 2005 7:36 AM Rants | Back to top

Comments on this post: Stored Procedures Holy War

No comments posted yet.
Your comment:
 (will show your gravatar)

Copyright © Scott Kuhl | Powered by: