This blog post is inspired from SQL Programming Joes 2 Pros: Programming and Development for Microsoft SQL Server 2008 – SQL Exam Prep Series 70-433 – Volume 4.
This is follow up blog post of my earlier blog post on the same subject - SQL SERVER – Introduction to SQL Error Actions – A Primer. In the article we discussed various basics terminology of the error handling. The article further covers following important concepts of error handling.
- Introduction to SQL Error Actions
- Statement Termination
- Scope Abortion
- Batch Termination
Above three are the most important concepts related to error handling and SQL Server. There are many more things one has to learn but without beginners fundamentals one can’t learn the advanced concepts. Let us have small quiz and check how many of you get the fundamentals right.
1.) Which SQL Server error action happens for errors with a severity of 11-16 when you set the XACT_ABORT setting to ON?
- You will get Statement Termination.
- You will get Scope Abortion.
- You will get Batch Abortion.
- You will get Connection Termination.
- SQL Server will pick the error action.
2.) Which SQL Server error action happens for errors with a severity of 11-16 when you set the XACT_ABORT setting to OFF?
- You will get Statement Termination
- You will get Scope Abortion
- You will get Batch Abortion
- You will get Connection Termination
- SQL Server will pick the error action
Now make sure that you write down all the answers on the piece of paper.
Watch following video and read earlier article over here. If you want to change the answer you still have chance.
Now compare let us check the answers and compare your answers to following answers. I am very confident you will get them correct.
Please leave your feedback in the comment area for the quiz and video. Did you know all the answers of the quiz?
Reference: Pinal Dave (http://blog.sqlauthority.com)