From the course: Complete Guide to Advanced SQL Server

Unlock the full course today

Join today to access over 24,400 courses taught by industry experts.

Generate errors with THROW

Generate errors with THROW

Sometimes SQL Server is perfectly happy executing an instruction that doesn't actually make sense for your specific database. For instance, a user sends a command to perform a task that's technically valid SQL, but the end result doesn't correspond to the business rules that your organization needs to follow. In these cases, you can create your own custom error messages using a command called THROW. The nice thing about THROW is that you can insert it anywhere that you want. It doesn't have to be attached to any actual database or server errors. To see how this can be helpful, I've got a TRY-CATCH statement set up here on Lines 7 through 13. The first thing that I'm doing is requesting a row from the people's table. Now, this SELECT statement should work just fine and is not going to generate any errors. Then on Line Number 9, we have our THROW command which will create an error that transfers execution into the CATCH block. The THROW command has three parts to it. First, we have a…

Contents