Session Ready
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, re-throw the original error.

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.