datacamp-logo
Session Ready
Exercise

CATCHING the RAISERROR

You need to select a product from the products table using a given product_id.

If the select statement doesn't find any product, you want to raise an error using the RAISERROR statement. You also need to catch possible errors in the execution.

For this exercise, the value of @product_id is 5.

Instructions 1/2
XP
  • 1
    • Set @product_id to 5.
    • Use the RAISERROR statement with a severity of 11, a state of 1 and the given @product_id.
  • 2
    • Catch the error generated by the RAISERROR statement you coded.
    • Select the error message using the appropriate function.