RAISERROR: RAISERROR raise an error with a user defined error message. The error message is either created dynamically or stored in the system table sysmessages. Example: Lets create a SP, pass 2 n…