批量更新表中某个字段值
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'
)
计算一个表中某字段合计值，并写入另一表中
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
