update 可选择语句
update @Table
set [Order Load]=CONVERT(INT,[Sell In])+CONVERT(INT,[BackLog]),WOS=case when [ST Weekly Average]=0 then 0 else
CONVERT(INT,[Close Inventory(Dec.12)])/CONVERT(INT,[ST Weekly Average]) end
set [Order Load]=CONVERT(INT,[Sell In])+CONVERT(INT,[BackLog]),WOS=case when [ST Weekly Average]=0 then 0 else
CONVERT(INT,[Close Inventory(Dec.12)])/CONVERT(INT,[ST Weekly Average]) end
