重庆分公司,新征程启航

为企业提供网站建设、域名注册、服务器等服务

SQL语句中事务与trycatch使用

普通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 的SQL事务处理:

begin  try
begin 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 try
begin catch
  print 'executed failed';
  rollback transaction tr
end catch

文章名称:SQL语句中事务与trycatch使用
标题来源:http://cqcxhl.com/article/goiois.html

其他资讯

在线咨询
服务热线
服务热线:028-86922220
TOP