Tag: TRANSACTION
TRY….CATCH Rollback Transaction In SQL Server 2005
This feature has been sometime in SQL Server 2005 in SQL Server 2000 you normally use @@TRANCOUNT to detect any exception but now in SQL Server 2005 you can use try catch block.
In this snippet, there are 2 INSERT statement and 1 UPDATE statement. I’m expecting when there is any failure (e.g the UPDATE statement [...]
Posted: May 23rd, 2009 under SQL Server.
Tags: ROLLBACK, SQL Server, TRANSACTION, TRY CATCH
Comments: none