From the course: Program Databases with Transact-SQL

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Generate errors with THROW

Generate errors with THROW - SQL Server Tutorial

From the course: Program Databases with Transact-SQL

Start my 1-month free trial

Generate errors with THROW

“

- Sometimes SQL server is perfectly happy, executing in 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 a server errors to see how this can be helpful, I've done a tri catch statement set up here on line seven 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 nine, 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…

Contents