admin 管理员组

文章数量: 1086019


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， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。