SQL try
2024-09-13 11:02:07
BEGIN TRY
-- Generate a constraint violation error.
DELETE FROM Production.Product
WHERE ProductID = 980;
END TRY
BEGIN CATCH
SELECT
ERROR_NUMBER() AS ErrorNumber,
ERROR_SEVERITY() AS ErrorSeverity,
ERROR_STATE() as ErrorState,
ERROR_PROCEDURE() as ErrorProcedure,
ERROR_LINE() as ErrorLine,
ERROR_MESSAGE() as ErrorMessage; IF @@TRANCOUNT > 0
ROLLBACK TRANSACTION;
END CATCH; IF @@TRANCOUNT > 0
COMMIT TRANSACTION;
GO
最新文章
- [Unity3D]引擎学习之注意事项(持续更新中)
- iOS 线程相关-----绝对de干货
- iOS 视频播放 - YVideoPlayer - UIView
- Hdu1093
- PSD 学位涵义 Poor, Smart and Deep desire to become rich 的缩写,不是真正的学位认证,是对一种心理状态的形容,所谓PSD学位是形容那些贫穷,但是很聪明,很深…_●.×
- 基于Spring Cloud和Netflix OSS构建微服务,Part 2
- iOS 使用 CATransform3D 处理 3D 影像、制做互动立体旋转的效果
- 201621123057 《Java程序设计》第14周学习总结
- 【Tomcat】Tomcat工作原理及简单模拟实现
- jQuery基础操作
- magento 2 Check https://getcomposer.org/doc/articles/troubleshooting.md#memory-limit-errors for more info on how to handle out of memory errors.%
- Selenium 3----窗口截图+关闭浏览器
- 开发框架模块视频系列(2)-Winform分页控件介绍
- 获取ScrollView ListView的当前位置的百分比
- centos6.6 安装adb环境
- 显示windows的音频的输入输出设备
- [Java in NetBeans] Lesson 16. Exceptions.
- LeetCode 606. Construct String from Binary Tree根据二叉树创建字符串 (C++)
- JVM内存管理---垃圾收集器
- Tomcat Connector