记录ID信息后,执行下列语句(需要将账套ID替换为对应的账套ID信息):
User uftsystem
delete from EAP_Period where cAcc_Id='账套ID' and iCurrentYear=2013
insert into EAP_Period
select cAcc_Id,iYear,iId,DBegin,DEnd,0,2013 from EAP_Period where iCurrentYear=2011
and cAcc_Id='账套ID'
update EAP_Period set DBegin=DATEADD(year,2,Dbegin),DEnd=DATEADD(year,2,dend)
where iCurrentYear=2013 and cAcc_Id='账套ID'