课程: Program Databases with Transact-SQL

今天就学习课程吧！

今天就开通帐号，24,100 门业界名师课程任您挑！

Capture errors with TRY and CATCH

Capture errors with TRY and CATCH - SQL Server教程

课程: Program Databases with Transact-SQL

开始一个月试用 购买团队方案

Capture errors with TRY and CATCH

“

- [Instructor] In your SQL server programs, error handling is most often implemented using Try and Catch blocks. The basic syntax is fairly simple. I've got an outline of what that looks like starting on line six and going down to line number 12. At the beginning of the routine, that you want to execute, add BEGIN TRY, then include all of the code you want to run. Assuming that it executes without any problems. After that, you'll have a line that says END TRY followed immediately by a BEGIN CATCH. If any errors are encountered in the TRY block, then the code in the CATCH block is executed. If the TRY block doesn't encounter any errors, then this portion is skipped over, finish the CATCH block with END CATCH . And then you can continue on with other code you want to execute after that. To put this into practice, let's try and execute an insert statement where we don't supply the values that we need for the required fields in a table. I've got that outlined here on line number 18, where…

内容