--总账开账SELECT iYear,iInitFlag,iOpenFlag,iIsUnload--UPDATE GL_Yearstate SET iInitFlag 0,iOpenFlag 1FROM GL_YearstateWHERE iYear2021--取消总账月结SELECT *--UPDATE GL_mend SET bflag 1FROM GL_mendWHERE iyear 2021--取消凭证记账SELECT ibook,*--UPDATE GL_accvouch SET ibook 1FROM GL_accvouchWHERE iyear 2021