select * into temp_a from ufsystem..ua_period where cacc_id='002'  and iyear='2022' order by iyear,iid

delete from ufsystem..ua_period where cacc_id='002'  and iyear='2022'

insert into ufsystem..ua_period  select * from temp_a 

drop table temp_a 

语句中的002是账套号，2022是年度，可根据实际修改，谢谢