批量 更新 Update Select

update T_Cash set T_Cash.cash_money=t.cash_money
,T_Cash.cash_date=getdate()
,T_Cash.creator=190
,T_Cash.creator_name='系统管理员'
FROM (
    select 1 fawen_id,1 cash_money
    union select 2,1
) t left join 
T_Cash c 
 on c.fawen_id=t.fawen_id
原文地址:https://www.cnblogs.com/gxivwshjj/p/6651239.html