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 » Best Practices » stored procedures   (RSS)
  • 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
  • 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
Privacy Statement