THROW vs. RAISERROR

sql-server, sql-server-2008-r2

Solution

Yes, it is, but only since 2012. If you're using 2008R2, then it didn't exist.

The definitions of state and severity are clearly documented in the raiserror documentation

Problem

I am trying to execute the following code: ``` THROW 51051, 'I come from the THROW construct :)', 1 ; ``` The error I am getting is: ``` Could not find stored procedure 'THROW'. ``` Isn't the `THROW` procedure a sytem procedure? Why can't it find it? Furthhermore, what is the difference between unsing `THROW` and `ErrorState` ? Is one older/newer/better than the other? And what do "ErrorSeverity" and "ErrorState" mean by `ErrorState`? Can I define them as I will or they are predefined?

Original source