Question

Purpose of TRY…CATCH block in SQL Server is ___________

(a) Error handling

(b) Stored Procedure handling

(c) Message handling

(d) None of the mentioned

I have been asked this question in a job interview.

This key question is from Error Handling in portion Developing with SQL Server of SQL Server

Answer 1

Right answer is (a) Error handling

The best I can explain: TRY… CATCH implements error handling for Transact-SQL that is similar to the exception handling in the Microsoft Visual C#.