Question

Point out the wrong statement.

(a) If an error occurs in the TRY block, control is not passed to another group of statements that is enclosed in a CATCH block

(b) If an error occurs in the TRY block, control is passed to another group of statements that is enclosed in a CATCH block

(c) If an error does not occur in the TRY block, control is passed to another group of statements that is enclosed in a CATCH block

(d) None of the mentioned

This question was posed to me in unit test.

I want to ask this question from Error Handling topic in chapter Developing with SQL Server of SQL Server

Answer 1

The correct option is (b) If an error occurs in the TRY block, control is passed to another group of statements that is enclosed in a CATCH block

Easiest explanation: A TRY…CATCH construct catches all execution errors that have a severity higher than 10 that do not close the database connection.