存储过程事务处理模板 

   1:  DECLARE @CurrentError int
   2:      BEGIN TRANSACTION
   3:      -- 开始更新数据的事务
   4:      /*
   5:          **这里执行业务操作**
   6:      */
   7:      -- 错误检查
   8:      SELECT @CurrentError = @@Error
   9:      IF @CurrentError != 0
  10:      BEGIN
  11:           GOTO ERROR_HANDLER
  12:      END
  13:      /*
  14:          **这里执行业务操作**
  15:      */
  16:      -- 错误检查    
  17:      SELECT @CurrentError = @@Error
  18:      IF @CurrentError != 0
  19:      BEGIN
  20:           GOTO ERROR_HANDLER
  21:      END
  22:      -- 事务结束
  23:      COMMIT TRANSACTION
  24:      RETURN 0
  25:      
  26:      ERROR_HANDLER:
  27:          ROLLBACK TRANSACTION
  28:          RETURN  @CurrentError

网上搜集 暂未测试
posted @ 2010-07-05 17:26  码尔代夫iimax  阅读(228)  评论(0)  编辑  收藏  举报