THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » stored procedures   (RSS)
  • Trick Question – Part Två

    This post is part two of an effort to examine, in brief, the decisions entailed in designing the interface between database and application. We’re in a strange place at this moment, where both the possibilities and the liabilities of techniques like ORM have come to a head, and it seems vital to go into data tier design at least equipped with all ...
    Posted to Merrill Aldrich (Weblog) by merrillaldrich on October 24, 2009
  • Bad habits to kick : using SELECT or RETURN instead of OUTPUT

    In my last post in this series, I covered the use of ''bad'' characters in entity names, such as spaces or dashes.  In this post I will talk about using RETURN and OUTPUT inappropriately. Jamie Thomson touched on part of this pet peeve in response to one of the other posts in this series.  So let me ask, do you see anything wrong ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on October 9, 2009
  • Parameters, Perms and Procs: Are You Really Protected from Injection?

    In my last post, Top 10 T-SQL Code Smells, I caught some flack got some feedback for including one (#3) about the use of Stored Procedures for Select statements. Several people expressed objections over the risk of SQL Injection, and how Stored Procs would prevent it, but some of the correspondence I've gotten made me worry that, perhaps, some of ...
    Posted to Merrill Aldrich (Weblog) by merrillaldrich on August 24, 2009
  • My stored procedure "best practices" checklist

    When developing stored procedures, there seems to be a lot of emphasis on ''get it done fast.'' Which means type all lower case, pay little attention to formatting, and sometimes throw best practices out the window. Personally, I would rather front-load my development time; I think that the costs I pay in initial development far outweigh what ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on October 30, 2008
  • Yet Another Stored Procedure vs. Ad-hoc Query Discussion?

    Earlier today, Will Sullivan posted a blog entry, My Statement on Stored Procedures, in which he emphatically states his official opinion of stored procedures as: ''I prefer not to use them.'' He then goes about dismissing most of the misinformation about why stored procedures are better than ad-hoc (parameterized) queries. The first bit of ...
    Posted to Peter DeBetta's SQL Programming Blog (Weblog) by Peter DeBetta on April 3, 2008
Privacy Statement