http://www.sqlservercentral.com/blogs/sql_awesomesauce/2013/06/20/try-catch-and-transactions/

Printed 2014/12/19 05:22PM

TRY, CATCH, and Transactions

By Jen McCown, 2013/06/20

The T-SQL TRY/CATCH structure (“new” in SQL 2005!) is, as the professionals say, da bomb. It’s also underused and under-understood, so let’s talk about the basics. (Or, you can skip to the summary at the end.) A group of Transact-SQL statements can be enclosed in a TRY block. If an error occurs in the TRY [...]
Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.