sql-server - 使用try catch回滚的T-SQL错误处理，错误行已删除

Question

我有以下构造。我注意到在while循环结束时删除了错误编号明显大于0的错误行。我不明白我在哪里犯错了。我是否需要catch部分中的第二个提交来提交错误号的更新？

while @@FETCH_STATUS = 0
  begin try
    begin transaction 
        [...insert something into a table here...]
        set @countrec = @countrec + @@rowcount 

    update Alarmtable
        set success = 0
      where Recno = @recno

    commit transaction 

  end try
  begin catch
    if @@trancount > 0 rollback transaction

    select @error = error_number()
         , @errormsg = error_message()  

    update Alarmtable 
      set success = @error 
    where Recno = @recno

    if @@trancount > 0 commit transaction

  end catch

  fetch next from listofrecords into 
        @recno, @alarmcontent

end /* while */

close listofrecords 
deallocate listofrecords 

delete Alarmtable 
   where success = 0 

Answer 1

删除了提交事务，并且错误条目也不再被删除。谢谢@kevchadders。