Tuesday, 15 March 2011

SQL Server --- using raiserror without status accident -


I want the user RAISERROR in my SQL-server code but I noticed that there is some status code Interference with built-in SQL error conditions ...

For example, the status code "1" is used for "zero error by devo", and I do not want to use it any more. .. Now I want to see what the status code is for the use of your blockage Of what?

If you want to use your own, then the value of more than 50000 value is created in that message Are reserved for. You can choose 'from sys.messages' to see the list of existing messages. 50000 is used when no value is provided.


No comments:

Post a Comment