raiserror in sql stored procedure code example
Example: sql raiserror
-- Syntax for SQL Server and Azure SQL Database
RAISERROR ( { msg_id | msg_str | @local_variable }
{ ,severity ,state }
[ ,argument [ ,...n ] ] )
[ WITH option [ ,...n ] ]