---
title: "T-sql 的Transaction模板"
author: "winzenghua"
date: "2011-03-02T15:42:00Z"
tags: []
slug: "t-sql-transaction"
draft: false
lastmod: "2011-03-02T15:42:00Z"
id: 948852
url: "https://java4gis.iteye.com/blog/948852"
---

### 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 &lt;&gt; 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