Home

Rule description

• CATCH clauses should do more than rethrow

Non-compliant Code Example

BEGIN TRY  
    EXECUTE usp_ExampleProc;  
END TRY  
BEGIN CATCH  
   THROW; --Non compliant code (In the catch block we simply throwing the exception)
END CATCH;

Compliant Code Example

BEGIN TRY  
    EXECUTE usp_ExampleProc;  
END TRY  
BEGIN CATCH  
    SELECT    --Compliant code (In the catch block we process the exception and throw)
        ERROR_NUMBER() AS ErrorNumber  
        ,ERROR_MESSAGE() AS ErrorMessage;  
    THROW;
END CATCH;