Automatic rollback due to SQL Server errors

From: http://www.cnblogs.com/masterfy/archive/2009/04/09/1432283.html

 

Alter procedure [DBO]. [usp_deletemm_sbkp] (@ id int)
Begin
Set xact_abort on -- roll back if an error occurs
Begin tran -- start transaction
......
-- Delete device Image Tag data
Delete A from configurationview A where exists (select 1 from configurationtree B where B. parentnodeid = (@ ID * 100 + 1) and A. nodeid = B. nodeid );

-- Delete a device
Delete from mm_sbkp
Where id = @ ID;

Commit tran -- submit a transaction

End

 

Set xact_abort on -- roll back if an error occursFor more information, see:
Http://msdn.microsoft.com/zh-cn/library/ms188792.aspx