Home Forums SQL Server 2005 T-SQL (SS2K5) T-SQL Coding - How do you code error handling logic in your SQL Server stored procedures? RE: T-SQL Coding - How do you code error handling logic in your SQL Server stored procedures?

  • April 21, 2015 at 2:55 pm

    #1792572

    It's a good idea to do some logging when an error are detected, as well as trying to recover or contain the error.

    And of course code defensively (detect the impossible happening and deal with it), and (paraphrasing Paul) correctly.

    Tom