当前位置: 代码迷 >> Sql Server >> 哪位高手看下这个存储过程,为什么进入了IF,求解。是不是@@ERROR用的有有关问题
  详细解决方案

哪位高手看下这个存储过程,为什么进入了IF,求解。是不是@@ERROR用的有有关问题

热度:20   发布时间:2016-04-27 14:32:38.0
谁看下这个存储过程,为什么进入了IF,求解。是不是@@ERROR用的有问题?
SQL code
BEGINSELECT @OrderRowCount = COUNT(*) FROM T_ORDER T WHERE T.DispOrderStatus != @CancelStatus AND [email protected]  AND [email protected]AND [email protected]IF(@OrderRowCount>0)     SET @ReturnValue= -1SELECT @rowCountArbitrate = COUNT(*) from T_ORDER T WHERE T.Arbitrate = 6 AND [email protected] AND [email protected]IF @rowCountArbitrate>0    set @ReturnValue = -3if exists (SELECT * FROM T_ORDER t WHERE [email protected] AND t.DispOrderStatus [email protected]  AND [email protected] AND t.ORDER_DATE>@date)    set @ReturnValue = -4  --可以保证,执行到这里的时候 @ReturnValue = -1,但为什么还会进入这个IF执行下面的,并且最后给我返回一个1--是不是我@@ERROR用的有问题。IF(@ReturnValue = 0 OR @ReturnValue IS NULL)        UPDATE T_CARD_STOCK SET [status] = @ShelfStatus WHERE [uid][email protected]             IF(@@ERROR = 0)                SET @ReturnValue = 1  --最后执行到了这里            ELSE                SET @ReturnValue = -2 return @ReturnValue END


------解决方案--------------------
SQL code
BEGINSELECT @OrderRowCount = COUNT(*) FROM T_ORDER T WHERE T.DispOrderStatus != @CancelStatus AND [email protected]  AND [email protected]AND [email protected]IF(@OrderRowCount>0)     SET @ReturnValue= -1SELECT @rowCountArbitrate = COUNT(*) from T_ORDER T WHERE T.Arbitrate = 6 AND [email protected] AND [email protected]IF @rowCountArbitrate>0    set @ReturnValue = -3if exists (SELECT * FROM T_ORDER t WHERE [email protected] AND t.DispOrderStatus [email protected]  AND [email protected] AND t.ORDER_DATE>@date)    set @ReturnValue = -4 print @ReturnValue --看下结果 --可以保证,执行到这里的时候 @ReturnValue = -1,但为什么还会进入这个IF执行下面的,并且最后给我返回一个1--是不是我@@ERROR用的有问题。IF(@ReturnValue = 0 OR @ReturnValue IS NULL)BEGIN        UPDATE T_CARD_STOCK SET [status] = @ShelfStatus WHERE [uid][email protected]             IF(@@ERROR = 0)                SET @ReturnValue = 1  --最后执行到了这里            ELSE                SET @ReturnValue = -2 END  -- tryreturn @ReturnValue END
  相关解决方案