Beginning with SQL Server 2005,"T-SQL Improvements in SQL Server 2012", Jonathan Allen on Mar 19, 2012, infoq.com Microsoft introduced additional TRY CATCH logic to support exception type behaviour. This behaviour enables developers to simplify their code and leave out @@ERROR checking after each SQL execution statement.
