av一区二区在线观看_亚洲男人的天堂网站_日韩亚洲视频_在线成人免费_欧美日韩精品免费观看视频_久草视

您的位置:首頁技術文章
文章詳情頁

sql server 2005中新增加的try catch學習

瀏覽:133日期:2023-10-30 10:45:29

sql server 2005中新增加的try catch,可以很容易捕捉異常了,今天大概學習看了下,歸納下要點如下

基本用法BEGIN TRY {; sql_statement | statement_block; }END TRYBEGIN CATCH {; sql_statement | statement_block }END CATCH,和普通語言的異常處理用法差不多,但要注意的是,SQL SERVER只捕捉那些不是嚴重的異常,當比如數據庫不能連接等這類異常時,是不能捕捉的一個例子:BEGIN TRY DECLARE @X INT -- Divide by zero to generate Error SET @X = 1/0 PRINT 'Command after error in TRY block'END TRYBEGIN CATCH PRINT 'Error Detected'END CATCHPRINT 'Command after TRY/CATCH blocks'; 另外try catch可以嵌套Begin TRY delete from GrandParent where Name = 'John Smith' print 'GrandParent deleted successfully'End TryBegin Catch Print 'Error Deleting GrandParent Record' Begin Try delete from Parent where GrandParentID = (select distinct ID from GrandParent where Name = 'John Smith') Print 'Parent Deleted Successfully' End Try Begin Catch print 'Error Deleting Parent' Begin Try delete from child where ParentId = (select distinct ID from Parent where GrandParentID = (select distinct ID from GrandParent where Name = 'John Smith')) print 'Child Deleted Successfully' End Try Begin Catch Print 'Error Deleting Child' End Catch End CatchEnd Catch另外,SQL SERVER 2005在異常機制中,提供了error類的方法方便調試,現摘抄如下,比較簡單,不予以解釋ERROR_NUMBER(): Returns a number associated with the error.ERROR_SEVERITY(): Returns the severity of the error.ERROR_STATE(): Returns the error state number associated with the error.ERROR_PROCEDURE(): Returns the name of the stored procedure or trigger in which the error occurred.ERROR_LINE(): Returns the line number inside the failing routine that caused the error. ERROR_MESSAGE(): Returns the complete text of the error message. The text includes the values supplied for any substitutable parameters, such as lengths, object names, or times. 最后舉例子如下,使用了error類的方法BEGIN TRY DECLARE @X INT -- Divide by zero to generate Error SET @X = 1/0 PRINT 'Command after error in TRY block'END TRYBEGIN CATCH PRINT 'Error Detected' SELECT ERROR_NUMBER() ERNumber, ERROR_SEVERITY() Error_Severity, ERROR_STATE() Error_State, ERROR_PROCEDURE() Error_Procedure, ERROR_LINE() Error_Line, ERROR_MESSAGE() Error_MessageEND CATCHPRINT 'Command after TRY/CATCH blocks'最后輸出Error DetectedErr_Num Err_Sev Err_State Err_Proc;;Err_Line; Err_Msg------- ------- --------- -------------------- --------- --------------------------------8134;;;;;16; 1 NULL 4;;;;;Divide by zero error encountered.

標簽: Sql Server 數據庫
主站蜘蛛池模板: 涩涩视频在线看 | 免费黄色在线观看 | 91久久精品日日躁夜夜躁欧美 | 成人精品视频在线观看 | 成人免费视频网站在线看 | 男女搞网站| 日日夜夜精品视频 | 亚洲一区 中文字幕 | 国产精品一级 | 国产乱码精品一区二区三区忘忧草 | 欧美综合一区二区三区 | 免费黄色a视频 | 亚洲精品无| 国产精品久久久久无码av | 国产成人精品视频 | 九九伊人sl水蜜桃色推荐 | 国产精品久久久久久一级毛片 | 91在线视频一区 | 午夜视频一区二区 | 男人av的天堂 | 精品粉嫩aⅴ一区二区三区四区 | 在线中文字幕视频 | 在线观看视频中文字幕 | 日韩精品免费视频 | 亚洲一二三区不卡 | 夜夜骚视频 | 欧美日韩视频在线播放 | 午夜精品一区二区三区免费视频 | 网站黄色在线免费观看 | 中文在线一区二区 | 色婷婷亚洲国产女人的天堂 | 天天干狠狠操 | 国产在线视频网 | 在线观看亚洲专区 | 国产精品久久二区 | 一级看片免费视频囗交动图 | 日韩视频a | 日韩免费一二三区 | 成人夜晚看av | 国产丝袜一区二区三区免费视频 | 成人精品一区亚洲午夜久久久 |