What is RAISEERROR in SQL Server ?
RAISERROR generates an error message and initiates error processing for the session. RAISERROR can either reference a user-defined message stored in the sys.messages catalog view or build a message dynamically.
The message is returned as a server error message to the calling application or an associated CATCH block of a TRY…CATCH construct.