You use Microsoft SQL Server 2012 to develop a database application. You create a stored
procedure named DeleteJobCandidate. You need to ensure that if DeleteJobCandidate encounters
an error, the execution of the stored procedure reports the error number. Which Transact-SQL
statement should you use?

A.
Option A

B.
Option B

C.
Option C

D.
Option D

Explanation:
http://msdn.microsoft.com/en-us/library/ms190193.aspx
http://msdn.microsoft.com/en-us/library/ms188790.aspx