The follow text is copied from this blog:
Official Blog of TechNet Wiki
Using Error Handling within the Transact SQL language needs a deep knowledge. It depends on the SQL Server version, there are various implementations for handling the errors in T-SQL. But if you use SQL Server 2012 or later versions, you can use the simplest and fully structured error handling.
Saeid Hasani showed how to implement such simple error handling in T-SQL. He showed this topic from a problem solving approach and particularly in SQL Server 2012 and the later versions. In this session, he covered some questions to providing a step by step tutorial for designing a structured error handling mechanism in SQL Server.
This session is available for download using the following links:
Original TN Wiki Article:
Judges’ comments for the article are from TechNet GURU Awards – September 2013 :
“Useful tutorial with lots of examples and very good links. Excellent comparison of THROW and RAISERROR.”
“Nice article. Thank you for the sharing.”
“Incredibly well formatted with images, code, and explanations. And great interactions in the comments, making the improvements suggested by Naomi. ”
“Useful, clear and accurate guidance on error handling”
“Great coverage of different techniques, challenges, pros/cons. Well done, very informative, and easy to read.”