- 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