September 2005
Error handling is an essential part of T-SQL code, but the use and misuse of error-handling routines is poorly understood. Use these error-handling templates to avoid pitfalls and catch errors before they snag your production code.
SQL Server Magazine