TNWikiSummit15 Presentation: Error Handling in SQL Server 2012 and 2014

 

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:

Video:

https://gallery.technet.microsoft.com/TN-Summit15-Structured-dfdcb9a5

PowerPoint:

https://gallery.technet.microsoft.com/TN-Summit15-Structured-118896bb

Original TN Wiki Article:

http://social.technet.microsoft.com/wiki/contents/articles/20002.structured-error-handling-mechanism-in-sql-server-2012.aspx

Judges’ comments for the article are from TechNet GURU Awards – September 2013 :

Richard Mueller:

“Useful tutorial with lots of examples and very good links. Excellent comparison of THROW and RAISERROR.”

Jinchun Chen:

“Nice article. Thank you for the sharing.”

Ed Price:

“Incredibly well formatted with images, code, and explanations. And great interactions in the comments, making the improvements suggested by Naomi. ”

DB:

“Useful, clear and accurate guidance on error handling”

Samuel Lester:

“Great coverage of different techniques, challenges, pros/cons. Well done, very informative, and easy to read.”

 

Advertisements
This entry was posted in Best Practices, Joy of T-SQL, SQL General Information, T-SQL Tips & Tricks. Bookmark the permalink.