#error handling in sql server

In my earlier essay, I discussed SQL Server's error handling in great detail. This is a follow-up post; it discusses RAISERROR, which produces an error message and initiates the session's error processing. The user-defined message stored in the sys.messag

In my earlier essay, I discussed SQL Server’s error handling in great detail. This is a follow-up post; it discusses RAISERROR, which produces an error message and initiates the session’s error processing. The user-defined message stored in the sys.messages catalog view may be referred to by RAISERROR, or a dynamic message may be created.Syntax:RAISERROR ( { msg_id | msg_str | @local_variable }{…