求NB的人写一语句

Question

update [order] set [order].iGoodsQoh=[order].iGoodsQoh + detail.siQty 
from detail where detail.iOrderID=6 and detail.cGoodsID=[order].cGoodsID

Answer 1

update t
set iGoodsQoh=isnull(t.iGoodsQoh,0)+A.siQty
from [order] t
join detail A on A.cGoodsID=t.cGoodsID
where A.iOrderID=6

Answer 2

update [order] set set iGoodsQoh=iGoodsQoh + detail.siQty
from detail where iOrderID=6 and detail.cGoodsID=order.cGoodsID

Answer 3

update order set  order.iGoodsQoh = order.iGoodsQoh + detail.siQty from order inner join detail on order.cGoodsID=detail.cGoodsID where detail.iOrderID=6

Answer 4

Update order 
set order.iGoodsQoh = order.iGoodsQoh + detail.siQty
from order,detail
where  order.cGoodsID=detail.cGoodsID and detail.iOrderID=6这样就可以了

Answer 5

Update order 
set order.iGoodsQoh = order.iGoodsQoh + detail.siQty
from order,detail
where  order.cGoodsID=detail.cGoodsID and detail.iOrderID=6

Answer 6

update [order]
set [order].[iGoodsQoh]=[order].[iGoodsQoh] + [detail].[siQty]
from [order] inner join [detail] on [detail].[cGoodsID]=[order].[cGoodsID]
where [detail].[iOrderID]=6