批量 更新 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
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