Most modern programming environments offers exception handling in some form, and SQL Server provides the popular TRY-CATCH concept. However, error handling in SQL Server is not as straight¬forward as one may wish, but it is marred with inconsistencies and unexpected behaviour. This session starts off by displaying the some of the surprises you can encounter, both when you use TRY-CATCH and when you don't. The session discusses why it is important to handle unexpected errors and presents a recipe for writing CATCH block where focus is on keeping things simple. You will learn why should not make your error handling "fancy", even if may seem to be a good idea in theory. The session also covers a few things to think of on client level.

This is a level 200 session main aimed at people who write T-SQL code as a developer or a DBA.