34,591
社区成员
发帖
与我相关
我的任务
分享SQL if语句执行两个执行语句体
if @iSide = 1
(set @InQty = @v1_qty*@v1_qtyop
set @OUInQty = @v1_ouqty*@v1_qtyop)
else
(set @OutQty = @v1_qty*@v1_qtyop*-1
set @ouOutQty = @v1_ouqty*@v1_qtyop*-1)
(set @InQty = @v1_qty*@v1_qtyop
set @OUInQty = @v1_ouqty*@v1_qtyop)
else
(set @OutQty = @v1_qty*@v1_qtyop*-1
set @ouOutQty = @v1_ouqty*@v1_qtyop*-1)
...全文
请发表友善的回复…
发表回复
吉普赛的歌 版主 2018-04-08
- 打赏
- 举报
--换 begin end
IF @iSide = 1
BEGIN
SET @InQty = @v1_qty * @v1_qtyop
SET @OUInQty = @v1_ouqty * @v1_qtyop
END
ELSE
BEGIN
SET @OutQty = @v1_qty * @v1_qtyop * -1
SET @ouOutQty = @v1_ouqty * @v1_qtyop * -1
END
