TRY...CATCH (Transact-SQL)

Implements error handling for Transact-SQL that is similar to the exception handling in the Microsoft Visual C# and Microsoft Visual C++ languages. A group of Transact-SQL statements can be enclosed in a TRY block. ... A TRY…CATCH construct catches all ..

msdn.microsoft.com