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 數據庫
主站蜘蛛池模板: 亚洲精选一区二区 | 国产成人精品久久二区二区 | 久久成人一区 | 欧美一级片在线 | 国产免费一区二区三区网站免费 | 黄色网址免费在线观看 | 欧美成人精品激情在线观看 | aaaa日韩| 成人国产精品一级毛片视频毛片 | 九九久久国产 | 久草精品视频 | 日韩成人免费av | 欧美激情一区二区三区 | 中文字幕在线网 | 精品无码三级在线观看视频 | 国产电影精品久久 | 国产美女自拍视频 | 久久精品免费 | 毛片免费观看 | 久久免费小视频 | 免费看啪啪网站 | 一区二区三区免费 | 一区二区伦理电影 | 黄色毛片大全 | 1级黄色大片 | 国产乱人伦精品一区二区 | 国产一区二区三区在线 | 国产精品s色| 男人av网| 自拍偷拍亚洲视频 | 丁香六月伊人 | 亚洲每日更新 | 精品日韩一区二区 | 色综合一区二区 | www.一级毛片 | 97碰碰碰| 天天操夜夜操 | 久久久久久久久久久久久9999 | 精品国产乱码久久久久久蜜臀 | 久久视频精品在线 | 国产精品一区在线观看 |