TSQL: Error handling with Try Catch from a .NET perspective

added by mehroz
5/12/2010 9:34:52 AM

0 Kicks, 63 Views

Starting with SQL 2005, we can handle unexpected situations in our TSQL scripts/procedures/functions in an structured manner using the famous Try/Catch methodology, similar to what we are used to in our object oriented programming languages (C#, Java, etc). This post will describe certain similarities and how to enjoy the features that look absent at the first look.