update在包含外部引用的被聚合表达式中指定了多个列

[_ShuMin]

update bi_bill
set Remark ='update SumForDiscount=SumForDiscount+SumOfConsume*(1-0.834)',
SumForDiscount=SumForDiscount+SumOfConsume*(1-0.834),
DiscountRate=0.834,DiscountName='会员折',DiscountID='99',
SumToPay=select (sum(SumOfConsume+SumOfService-SumForDiscount)) from bi_bill
where BillID='XS-180327-0002'

[卖水果的net]

-- 最后一个，加个括号

update bi_bill
   set Remark         = 'update SumForDiscount=SumForDiscount+SumOfConsume*(1-0.834)',
       SumForDiscount = SumForDiscount + SumOfConsume * (1 - 0.834),
       DiscountRate   = 0.834,
       DiscountName   = '会员折',
       DiscountID     = '99',
       SumToPay       =  (select (sum(SumOfConsume + SumOfService - SumForDiscount))
                           from bi_bill
                          where BillID = 'XS-180327-0002')

[二月十六]

UPDATE  bi_bill
SET     Remark = 'update SumForDiscount=SumForDiscount+SumOfConsume*(1-0.834)' ,
        SumForDiscount = SumForDiscount + SumOfConsume * ( 1 - 0.834 ) ,
        DiscountRate = 0.834 ,
        DiscountName = '会员折' ,
        DiscountID = '99' ,
        SumToPay = ( SELECT ( SUM(SumOfConsume + SumOfService - SumForDiscount) )
                     FROM   bi_bill
                     WHERE  BillID = 'XS-180327-0002'
                   )