nb.sql

来自「一个用VB写的财务软件源码」· SQL 代码 · 共 28 行

insert INTO TGD_DEPARTMENT<<YEAR>> SELECT * FROM TGD_DEPARTMENT<<PREYEAR>>;
insert INTO TUSU_DEPARTMENT<<YEAR>> SELECT * FROM TUSU_DEPARTMENT<<PREYEAR>>;
insert INTO TUSU_KMTOXMCLASS<<YEAR>> SELECT * FROM TUSU_KMTOXMCLASS<<PREYEAR>>;
insert INTO TYSYF_BADACCOUNTKM<<YEAR>> SELECT * FROM TYSYF_BADACCOUNTKM<<PREYEAR>>;
insert INTO TZW_ACCOUNTAGE<<YEAR>> SELECT * FROM TZW_ACCOUNTAGE<<PREYEAR>>;
insert INTO TZW_BADACCOUNTAGE<<YEAR>> SELECT * FROM TZW_BADACCOUNTAGE<<PREYEAR>>;
insert INTO TZW_BALANCE<<YEAR>>(KMDM,KMMC,YEFX,BZ) (SELECT KMDM,KMMC,YEFX,BZ FROM TZW_BALANCE<<PREYEAR>>);
insert INTO TZW_CUSTOMER<<YEAR>> SELECT * FROM TZW_CUSTOMER<<PREYEAR>>;
insert INTO TZW_CUSTOMERCLASS<<YEAR>> SELECT * FROM TZW_CUSTOMERCLASS<<PREYEAR>>;
insert INTO TZW_CUSTOMERSHOWSET<<YEAR>> SELECT * FROM TZW_CUSTOMERSHOWSET<<PREYEAR>>;
insert INTO TZW_EXCH<<YEAR>> SELECT * FROM TZW_EXCH<<PREYEAR>>;
insert INTO TZW_FOREIGNCURRENCY<<YEAR>> SELECT * FROM TZW_FOREIGNCURRENCY<<PREYEAR>>;
insert INTO TZW_IGENERALDATA<<YEAR>> SELECT * FROM TZW_IGENERALDATA<<PREYEAR>>;
insert INTO TZW_IGENERALSTRUCT<<YEAR>> SELECT * FROM TZW_IGENERALSTRUCT<<PREYEAR>>;
insert INTO TZW_ITEM<<YEAR>> SELECT * FROM TZW_ITEM<<PREYEAR>>;
insert INTO TZW_ITEMCLASS<<YEAR>> SELECT * FROM TZW_ITEMCLASS<<PREYEAR>>;
insert INTO TZW_JSFS<<YEAR>> SELECT * FROM TZW_JSFS<<PREYEAR>>;
insert INTO TZW_KM<<YEAR>> SELECT * FROM TZW_KM<<PREYEAR>>;
update TZW_KM<<YEAR>> SET BUSE=0,ISFC=0;
insert INTO TZW_TEMPLETDETAIL<<YEAR>> SELECT * FROM TZW_TEMPLETDETAIL<<PREYEAR>>;
insert INTO TZW_TEMPLETMAIN<<YEAR>> SELECT * FROM TZW_TEMPLETMAIN<<PREYEAR>>;
insert INTO TZW_TYPE<<YEAR>> SELECT * FROM TZW_TYPE<<PREYEAR>>;
insert INTO TZW_VENDOR<<YEAR>> SELECT * FROM TZW_VENDOR<<PREYEAR>>;
insert INTO TZW_VENDORCLASS<<YEAR>> SELECT * FROM TZW_VENDORCLASS<<PREYEAR>>;
insert INTO TZW_VENDORSHOWSET<<YEAR>> SELECT * FROM TZW_VENDORSHOWSET<<PREYEAR>>;
insert INTO TZW_ZZHDSET<<YEAR>> SELECT * FROM TZW_ZZHDSET<<PREYEAR>>;
insert INTO TZW_ZZPZSET<<YEAR>> SELECT * FROM TZW_ZZPZSET<<PREYEAR>>;