SQL Server RAISEERROR Statement !!

Question

What does Raiserror do in SQL Server? Can someone tell me with the example?

Naimish Makwana · Answer

Hi Aradhana, The RAISERROR statement allows you to generate your own error messages and return these messages back to the application using the same format as a system error or warning message generated by SQL Server Database Engine. In addition, the RAISERROR statement allows you to set a specific message id, level of severity, and state for the error messages. The following illustrates the syntax of the RAISERROR statement: RAISERROR ( { message_id | message_text | @local_variable } { ,severity ,state } [ ,argument [ ,...n ] ] ) [ WITH option [ ,...n ] ]; examples DECLARE @ErrorMessage NVARCHAR(4000), @ErrorSeverity INT, @ErrorState INT; BEGIN TRY RAISERROR('My Custome exception message.', 17, 1); END TRY BEGIN CATCH SELECT @ErrorMessage = ERROR_MESSAGE(), @ErrorSeverity = ERROR_SEVERITY(), @ErrorState = ERROR_STATE(); -- return the error inside the CATCH block RAISERROR(@ErrorMessage, @ErrorSeverity, @ErrorState); END CATCH; Here is the output: Msg 50000, Level 17, State 1, Line 16 My Custome exception message. For more details, refer : https://www.sqlservertutorial.net/sql-server-stored-procedures/sql-server-raiserror/ Thanks Naimish

Vishal Yelve · Answer

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 to an associated CATCH block of a TRY...CATCH construct. do refer below link https://learn.microsoft.com/en-us/sql/t-sql/language-elements/raiserror-transact-sql?view=sql-server-ver16

Sachin Singh · Answer

You can follow this article for detailed explaination https://www.sqlservertutorial.net/sql-server-stored-procedures/sql-server-raiserror/

Aravind Govindaraj · Answer

On a high level, it's used to get messages from the backend to the front-end application or call a spot. It may be information or error based on how you use the raise error

Rajeev Kumar · Answer

The RAISERROR statement allows you to generate your own error messages and return these messages back to the application using the same format as a system error or warning message generated by SQL Server Database Engine. In addition, the RAISERROR statement allows you to set a specific message id, level of severity, and state for the error messages. DECLARE @ErrorMessage NVARCHAR(4000), @ErrorSeverity INT, @ErrorState INT; BEGIN TRY RAISERROR('Error occurred in the TRY block.', 17, 1); END TRY BEGIN CATCH SELECT @ErrorMessage = ERROR_MESSAGE(), @ErrorSeverity = ERROR_SEVERITY(), @ErrorState = ERROR_STATE(); -- return the error inside the CATCH block RAISERROR(@ErrorMessage, @ErrorSeverity, @ErrorState); END CATCH;