Raising a message not defined in sysmessages. : RAISERROR « Transact SQL « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. Transact SQL
  3. RAISERROR
6> DECLARE @chrPrintMsg CHAR(255)
7> 
8> RAISERROR('Undefined error raised using the WITH SETERROR option',1,2) WITH SETERROR
9>
10> SELECT @chrPrintMsg = 'Using WITH SETERROR sets the error number generated to ' + CONVERT(char,@@error)
11> PRINT @chrPrintMsg
12> GO
Undefined error raised using the WITH SETERROR option
Using WITH SETERROR sets the error number generated to 50000








20.21.RAISERROR
20.21.1.RAISERROR syntax
20.21.2.Using RAISERROR without an Error Number
20.21.3.RAISERROR (50001, 15, -1, @parm1, @parm2)
20.21.4.Raise exception with parameters
20.21.5.The syntax of the RAISERROR statement: RAISERROR ({message_id|message_string}, severity, state [, argument]...)
20.21.6.Raising a message not defined in sysmessages.
20.21.7.Raise error out of a procedure
20.21.8.Raise error in case of error
20.21.9.Using RAISERROR with the SETERROR Option