try/catch in T-SQL

This suggests that you'll wrap a blob of SQL in bookends of BEGIN TRY and END TRY and follow it up with another blob with bookends of BEGIN CATCH and END CATCH such that END TRY is immediately follwed by BEGIN CATCH. To make the catch throw the error use THROW and if you don't the exception will be swallowed.