Exercise

THROW without parameters

You want to prepare a stored procedure to insert new products in the database. In that stored procedure, you want to insert the possible errors in a table called errors, and after that, throw the error again.

How do you prepare the stored procedure?

Instructions

100 XP

Surround the error handling with a CATCH block.
Insert the error in the errors table.
End the insert statement with a semicolon (;).
Re-throw the original error.

Take Hint (-30 XP)