UPDATE的两个实例

1. 批量更新表中某个字段值

UPDATE T_BD_MATERIAL 
SET F_BGL_PRICE = CASE FNUMBER 
when 301010001 then 109.4
when 301010002 then 67.92
when 301010003 then 70.02
END 
WHERE FNUMBER IN ('301010001',
'301010002',
'301010003'
)

2. 计算一个表中某字段合计值，并写入另一表中

update  T_ENG_BOM  set F_ora_Decimal = date.total
from (select FID,sum(F_ora_RefCostTotal) total from T_ENG_BOMCHILD group by FID )date ,T_ENG_BOM
where T_ENG_BOM.FID = date.FID