SQL Server 2012: Transact-SQL Error Handling

By Joe Sack
Learn how to write Transact-SQL code that deals correctly with anticipated and unanticipated errors during code execution, for developers and DBAs from SQL Server 2005 onward
Course info
Level
Intermediate
Updated
Aug 21, 2013
Duration
1h 21m
Table of contents
Course Introduction
Course Introduction 1m Where should our error handling live? 1m Course Structure 1m
Command Fundamentals
Module Introduction 1m RAISERROR 2m Demo: RAISERROR 5m TRY...CATCH 1m Demo: Legacy Error Handling 5m Demo: TRY... CATCH Error Handling 3m Demo: Nested TRY... CATCH 4m Demo: TRY... CATCH Gaps 4m Error Information 1m Demo: @@ERROR 2m Demo: CATCH Block Error Information 2m THROW 1m Demo: THROW with TRY CATCH 2m Demo: THROW Outside of TRY CATCH 2m Transaction Commands 2m Demo: Transaction Handling and TRY CATCH 2m Demo: Transaction Handling and XACT_ABORT 3m Demo: Transaction Handling with THROW vs. RAISERROR 2m Demo: Checking Transaction States 3m Demo: Doomed Transaction Handling 2m
Message Handling
Module Introduction 1m sys.messages 1m Demo: sys.messages 1m Severity Levels 1m User-Defined Error Message Definition 1m Demo: Managing User-Defined Error Messages 3m FORMATMESSAGE 0m Demo: FORMATMESSAGE 2m
Error Handling Techniques
Module Introduction 1m Demo: Unplanned Error Handling Template 3m Demo: Unplanned Error Handling Template - Implementation Example 2m Demo: Planned Error Handling Template 3m Demo: Planned Error Handling Template - Implementation Example 3m Demo: Unhandled Deadlock Example 1m Demo: Handled Deadlock Example 1m Demo: Handled Deadlock Example - with Retry 3m Demo: Creating an Error Logging Procedure and Table 2m Demo: Using the Error Logging Procedure and Table 2m Course Summary 0m
Description
Course info
Level
Intermediate
Updated
Aug 21, 2013
Duration
1h 21m
Description

Robust Transact-SQL coding practices dictate proactive planning for anticipated and unanticipated errors that might occur during code module execution. SQL Server’s flavor of Transact-SQL provides several commands that can be used to properly handle errors in your code and this course will cover the fundamental commands you’ll need to know, as well as effective error handling techniques that will help you properly handle issues for high throughput, mission-critical data tiers. This course is perfect for developers, DBAs, and anyone responsible for writing Transact-SQL code, from complete beginners through to those with more experience. The information in the course applies to all versions from SQL Server 2005 onward, with some emphasis on new SQL Server 2012 commands.

About the author
Joe Sack
About the author

Joe Sack is a Principal Program Manager in the SQL Server and Azure SQL Database product team at Microsoft, with a focus on query processing. With over 19 years of experience in the industry, Joe is an author and speaker, specializing in performance tuning and optimization.

More from the author
SQL Server: Common Query Tuning Problems and Solutions - Part 2
Intermediate
2h 17m
Aug 11, 2014
SQL Server: Common Query Tuning Problems and Solutions - Part 1
Intermediate
2h 31m
Jul 7, 2014
SQL Server: Transact-SQL Common Table Expressions
Intermediate
1h 21m
Feb 14, 2014
More courses by Joe Sack

You're the smartest person in the room

PROVE IT

Your team won't just close the skills gap

THEY'LL HURDLE IT