SQL Server Tutorial : Error anatomy and uncatchable errors

Want to learn more? Take the full course at https://learn.datacamp.com/courses/transactions-and-error-handling-in-sql-server at your own pace. More than a video, you'll learn hands-on coding & quickly apply skills to your daily work. --- In this lesson, you will study the anatomy of errors. You will also learn which errors can't be detected by a TRY...CATCH construct. Do you remember what happened when we tried to insert a new product with a name which was already stored in the products table? We got this error. The first line of this error has several data which will be analyzed in the next slides. The rest of the lines are the message text of the error. In the first line of the error, the first value is the error number, 2627 in this example. When SQL Server raises an error, this number can be in the range from 1 to 49999. You can also create your own errors starting from 50001. If you want to know the complete catalog of error numbers, you can check them in the sys.messages view. The second value is the severity level, 14 in this example. Severity levels from 0 to 10 are informational messages. The errors with this level of severity are treated as warnings. Levels from 11 to 16 are errors that can be corrected by the user. For example, constraint violations, as we got in our error message. Levels from 17 to 24 are other kinds of errors, such as software problems or fatal errors. The complete list of severity levels is available through Microsoft. The third value is the state. It can give you more information about the error. It will be 1 if SQL Server displays the error to the user. If you raise your own error, you can choose a value between 0 and 255. The last value is the line. It indicates on which line the error occurred. Finally, if the error happened within a stored procedure or a trigger, you will receive this extra data, giving you the name of the stored procedure or the name of the trigger. The TRY...CATCH construct we learned can't catch every k