(轉)sql server 事務與try catch

標籤：

本文轉載自：http://www.cnblogs.com/sky_Great/archive/2013/01/09/2852417.html

sql普通事務

begin transaction tr   declare @error int;   set @error=0;   select * from Car_Brand   set @error=@error+@@ERROR   select 1/0   set @error=@error+@@ERROR   select * from AREA   set @error=@error+@@ERROR   print ‘i have executed!‘   set @error=@error+@@ERROR      print ‘@@error:‘+cast(@error as varchar(50))   if(@error<>0)     begin      print ‘executed failed‘;      rollback transaction tr     end   else         begin      print ‘executed success‘;      commit transaction tr     end

 

結合try catch 的事務

begin  trybegin transaction tr   select * from Car_Brand   update car_log set [reason]=‘ceshiceshiceshi‘ where [modelid]=557;   select 1/0   print ‘i have executed!‘   select * from AREA         print ‘executed success‘;   commit transaction tr      end trybegin catch  print ‘executed failed‘;  rollback transaction trend catch

 

(轉)sql server 事務與try catch