Exercise

THROW with parameters

You need to prepare a script to select all the information of a member from the staff table using a given staff_id.

If the select statement doesn't find any member, you want to throw an error using the THROW statement. You need to warn there is no staff member with such id.

Instructions

100 XP

Set @staff_id to 4.
Use the THROW statement, with 50001 as the error number, 'No staff member with such id' as the message text, and 1 as the state.

Take Hint (-30 XP)