T-sql 的Transaction模板
很简单的模板,开始一个Transaction,然后运行一些命令。最后根据情况来判断是否Commit
如果在中间出了严重故障,无法在程序中终止,可以在Management Studio中关闭当前命令窗口,Sqlserver会提示,是否终止未完成的Transaction, 选择No即可。
-- Transaction template
Begin Try
Begin Transaction updateWLReg
Begin
-- leave your code here
End
IF @@ERROR <> 0
BEGIN
print 'rollback transaction because there is a error'
ROLLBACK TRANSACTION
END
ELSE
begin
print 'commiting'
---- change this to Rollback during debuging phase
-- ROLLBACK TRANSACTION
Commit TRANSACTION
end
End Try
Begin Catch
print 'exception happens'
SELECT ERROR_NUMBER() ERNumber,
ERROR_SEVERITY() ErrorSeverity,
ERROR_STATE() ErrorState,
ERROR_PROCEDURE() ErrorProcedure,
ERROR_LINE() ErrorLine,
ERROR_MESSAGE() ErrorMessage
ROLLBACK TRANSACTION
End Catch
分享到:
相关推荐
Transact-SQL, or T-SQL, is Microsoft Corporation’s powerful implementation of the ANSI standard SQL database query language, which was designed to retrieve, manipulate, and add data to relational ...
Preparation of Papers for IEEE TRANSACTIONS and JOURNALS
TCC-Transaction分布式事务DEMO,基于Mysql数据库的事务,包括分布式提交和回滚,例子完成,可以正常跑,基于Maven构建的项目
Transact-SQL编程规范 Transact-SQL编程规范 1 概述 3 1.1.基本原则 3 1.2.基本规范 3 命名规范 3 1.3.对象命名 4 1.3.1. 数据库 4 1.3.2. 数据库文件 4 1.3.3. 关系型数据仓库 4 1.3.4. 数据架构 4 1.3.5. 数据表 5...
顶级投行、金融估值建模培训资料-Precedent Transaction Analysis _ Street Of Walls.pdf
SAP System Administration - Relevant Transaction Codes by Klaus Utech Date Stamp: 2008-04-22
spring-hibernate-maven-transaction整合
jboss-transaction-api
known to the information processing community—from transaction to batch processing to analytical processing. In most cases, the primary focus of the early database systems was operational—usually ...
jar包大小:93KB commons-transaction-1.2.jar jar包大小:141KB commons-scxml-0.6.jar jar包大小:254KB commons-primitives-1.0.jar jar包大小:60KB commons-pool-1.3.jar jar包大小:176KB commons-net-1.4.1.jar ...
java运行依赖jar包
ARIES - A Transaction Recovery Method Supporting Fine-Granularity Locking and Partial Rollbacks Using Write-Ahead Logging.pdf Algorithm for Recouery and Isolation Exploiting Semantics), which ...
│ T-SQL(1).sql │ 收藏SQL语句.sql │ 精妙SQL语句收集_sql.sql │ ├─05 T-SQL编程 │ T-SQL.sql │ ├─06 视图 │ SysView.sql │ view.sql │ ├─07 事务 │ transaction.sql │ ├─08 存储过程 │ ...
xa-sqlsever配置:解决java后台问题javax.transaction.xa.XAException: java.sql.SQLException: 无法创建 XA 控制连接。错误: 未能找到存储过程 'master..xp_sqljdbc_xa_init';内含有详细说明,操作步骤简单易懂,...
04-infosec-101-for-icos-how-the-most-secure-transaction-protocol-failed
分布式事务演示-distributed-transaction-demo
官方离线安装包,测试可用。使用rpm -ivh [rpm完整包名] 进行安装
jboss-transaction
分布式简易事务回滚框架:biz-center-base-transaction
Laravel开发-laravel-transaction-observer 观察延迟事件,并在完成所有事务后触发它们。