SQL Server Tutorial : Transactions and Error Handling in SQL Server

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. --- Hello, and welcome to Transactions and Error Handling in SQL Server. This is Miriam Antona. I am a software engineer, and I will be your instructor for this course. In this course, you will study how to handle errors in SQL Server, which will be covered in Chapters 1 and 2. In chapter 3 you will learn what transactions are and how to work with them. In the last chapter, chapter 4, you will understand what concurrency is and how it can affect transactions. We will practice the concepts related to error handling with a dataset based on an electric bike store. It contains information about products, buyers, staff, and orders. Let's start with an example where an error occurs. In the products table, there is a Trek Powerfly 5 - 2018 bicycle. In this table, there is a constraint which checks that every product name must be unique. So, what happens if I try to insert again a new product with the name Trek Powerfly 5 - 2018? We get this error. We can handle this kind of error using a TRY...CATCH construct. If you have experience with other programming languages, this syntax may look familiar to you. With this TRY...CATCH structure you can implement error handling. A TRY...CATCH structure is made up of a TRY block and a CATCH block. A TRY block starts with BEGIN TRY and ends with END TRY. A CATCH block starts with BEGIN CATCH and ends with END CATCH. You can enclose your statements within the TRY block. In the CATCH block, you can place your error handling code. If an error occurs in the TRY block, then the CATCH block takes the control. The CATCH block is only skipped if there is no error in the TRY block. Let's see some examples. Let's go back to the example where we got an error. Remember we tried to insert a new bicycle