admin 管理员组文章数量: 1087139
2024年3月19日发(作者：jsp被淘汰之后用的是什么)
7. BEGIN CATCH
8. SELECT
9. ERROR_NUMBER() AS ErrorNumber,
10. ERROR_SEVERITY() AS ErrorSeverity,
11. ERROR_STATE() AS ErrorState,
12. ERROR_PROCEDURE() AS ErrorProcedure,
13. ERROR_LINE() AS ErrorLine,
14. ERROR_MESSAGE() AS ErrorMessage;
15. END CATCH;
16. GO
[sql]
1. USE AdventureWorks;
2. GO
3. BEGIN TRANSACTION;
4.
5. BEGIN TRY
6. -- Generate a constraint violation error.
7. DELETE FROM t
8. WHERE ProductID = 980;
9. END TRY
10. BEGIN CATCH
11. SELECT
12. ERROR_NUMBER() AS ErrorNumber,
13. ERROR_SEVERITY() AS ErrorSeverity,
14. ERROR_STATE() as ErrorState,
15. ERROR_PROCEDURE() as ErrorProcedure,
16. ERROR_LINE() as ErrorLine,
17. ERROR_MESSAGE() as ErrorMessage;
18.
19. IF @@TRANCOUNT > 0
20. ROLLBACK TRANSACTION;
21. END CATCH;
22. IF @@TRANCOUNT > 0
23. COMMIT TRANSACTION;
24. GO
版权声明：本文标题：SQLServer异常处理机制(BegintryBeginCatch) 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://roclinux.cn/p/1710785972a573043.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。
发表评论