nb.sql

一个用VB写的财务软件源码

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