Try/Catch Blocks - T-SQL Step by Step Course - Lesson 29 | SQL courses

Duration: 19:01 min

Summary: Today, we will discuss try/catch blocks. So, the idea is that if there is a piece of code that can cause problems (or exceptions), we put that code in a try section. If an exception occurs, the execution is transferred to the catch section. Then, the code will proceed normally after the catch. If an exception does not occur, the whole catch section is skipped. As we are testing this concept, we will use the built-in error functions to get the error number, error line, and error message and print them on the screen. We will look at different statements and their impact on exceptions.