审计时，备份现有账套，如何得出以前年度账套

EXEC sp_rename 'DA_main ', 'DA_main0'

两步：

第一步：把当前年度表名加年度

第二步：要审计的年度去了表名年度

EXEC sp_rename 'ztinfo', 'ztinfo2099'

EXEC sp_rename 'ZTXXCFG', 'ZTXXCFG2099'

EXEC sp_rename 'ZTperiod', 'ZTperiod2099'

EXEC sp_rename 'Tbrepinfor', 'Tbrepinfor2099'

EXEC sp_rename 'TPZ', 'TPZ2099'

EXEC sp_rename 'printFmt', 'printFmt2099'

EXEC sp_rename 'KM', 'KM2099'

EXEC sp_rename 'KMZD', 'KMZD2099'

EXEC sp_rename 'pzmain', 'pzmain2099'

EXEC sp_rename 'pzitem', 'pzitem2099'

EXEC sp_rename 'ztinfo2013', 'ztinfo'

EXEC sp_rename 'ZTXXCFG2013', 'ZTXXCFG'

EXEC sp_rename 'ZTperiod2013', 'ZTperiod'

EXEC sp_rename 'Tbrepinfor2013', 'Tbrepinfor'

EXEC sp_rename 'TPZ2013', 'TPZ'

EXEC sp_rename 'printFmt2013', 'printFmt'

EXEC sp_rename 'KM2013', 'KM'

EXEC sp_rename 'KMZD2013', 'KMZD'

EXEC sp_rename 'pzmain2013', 'pzmain'

EXEC sp_rename 'pzitem2013', 'pzitem'

EXEC sp_rename 'ztinfo2012', 'ztinfo'

EXEC sp_rename 'ZTXXCFG2012', 'ZTXXCFG'

EXEC sp_rename 'ZTperiod2012', 'ZTperiod'

EXEC sp_rename 'Tbrepinfor2012', 'Tbrepinfor'

EXEC sp_rename 'TPZ2012', 'TPZ'

EXEC sp_rename 'printFmt2012', 'printFmt'

EXEC sp_rename 'KM2012', 'KM'

EXEC sp_rename 'KMZD2012', 'KMZD'

EXEC sp_rename 'pzmain2012', 'pzmain'

EXEC sp_rename 'pzitem2012', 'pzitem'

EXEC sp_rename 'ztinfo2011', 'ztinfo'

EXEC sp_rename 'ZTXXCFG2011', 'ZTXXCFG'

EXEC sp_rename 'ZTperiod2011', 'ZTperiod'

EXEC sp_rename 'Tbrepinfor2011', 'Tbrepinfor'

EXEC sp_rename 'TPZ2011', 'TPZ'

EXEC sp_rename 'printFmt2011', 'printFmt'

EXEC sp_rename 'KM2011', 'KM'

EXEC sp_rename 'KMZD2011', 'KMZD'

EXEC sp_rename 'pzmain2011', 'pzmain'

EXEC sp_rename 'pzitem2011', 'pzitem'

EXEC sp_rename 'ztinfo2010', 'ztinfo'

EXEC sp_rename 'ZTXXCFG2010', 'ZTXXCFG'

EXEC sp_rename 'ZTperiod2010', 'ZTperiod'

EXEC sp_rename 'Tbrepinfor2010', 'Tbrepinfor'

EXEC sp_rename 'TPZ2010', 'TPZ'

EXEC sp_rename 'printFmt2010', 'printFmt'

EXEC sp_rename 'KM2010', 'KM'

EXEC sp_rename 'KMZD2010', 'KMZD'

EXEC sp_rename 'pzmain2010', 'pzmain'

EXEC sp_rename 'pzitem2010', 'pzitem'

EXEC sp_rename 'ztinfo2009', 'ztinfo'

EXEC sp_rename 'ZTXXCFG2009', 'ZTXXCFG'

EXEC sp_rename 'ZTperiod2009', 'ZTperiod'

EXEC sp_rename 'Tbrepinfor2009', 'Tbrepinfor'

EXEC sp_rename 'TPZ2009', 'TPZ'

EXEC sp_rename 'printFmt2009', 'printFmt'

EXEC sp_rename 'KM2009', 'KM'

EXEC sp_rename 'KMZD2009', 'KMZD'

EXEC sp_rename 'pzmain2009', 'pzmain'

EXEC sp_rename 'pzitem2009', 'pzitem'

EXEC sp_rename 'ztinfo2008', 'ztinfo'

EXEC sp_rename 'ZTXXCFG2008', 'ZTXXCFG'

EXEC sp_rename 'ZTperiod2008', 'ZTperiod'

EXEC sp_rename 'Tbrepinfor2008', 'Tbrepinfor'

EXEC sp_rename 'TPZ2008', 'TPZ'

EXEC sp_rename 'printFmt2008', 'printFmt'

EXEC sp_rename 'KM2008', 'KM'

EXEC sp_rename 'KMZD2008', 'KMZD'

EXEC sp_rename 'pzmain2008', 'pzmain'

EXEC sp_rename 'pzitem2008', 'pzitem'

EXEC sp_rename 'ztinfo2007', 'ztinfo'

EXEC sp_rename 'ZTXXCFG2007', 'ZTXXCFG'

EXEC sp_rename 'ZTperiod2007', 'ZTperiod'

EXEC sp_rename 'Tbrepinfor2007', 'Tbrepinfor'

EXEC sp_rename 'TPZ2007', 'TPZ'

EXEC sp_rename 'printFmt2007', 'printFmt'

EXEC sp_rename 'KM2007', 'KM'

EXEC sp_rename 'KMZD2007', 'KMZD'

EXEC sp_rename 'pzmain2007', 'pzmain'

EXEC sp_rename 'pzitem2007', 'pzitem'

EXEC sp_rename 'ztinfo2006', 'ztinfo'

EXEC sp_rename 'ZTXXCFG2006', 'ZTXXCFG'

EXEC sp_rename 'ZTperiod2006', 'ZTperiod'

EXEC sp_rename 'Tbrepinfor2006', 'Tbrepinfor'

EXEC sp_rename 'TPZ2006', 'TPZ'

EXEC sp_rename 'printFmt2006', 'printFmt'

EXEC sp_rename 'KM2006', 'KM'

EXEC sp_rename 'KMZD2006', 'KMZD'

EXEC sp_rename 'pzmain2006', 'pzmain'

EXEC sp_rename 'pzitem2006', 'pzitem'

EXEC sp_rename 'ztinfo2005', 'ztinfo'

EXEC sp_rename 'ZTXXCFG2005', 'ZTXXCFG'

EXEC sp_rename 'ZTperiod2005', 'ZTperiod'

EXEC sp_rename 'Tbrepinfor2005', 'Tbrepinfor'

EXEC sp_rename 'TPZ2005', 'TPZ'

EXEC sp_rename 'printFmt2005', 'printFmt'

EXEC sp_rename 'KM2005', 'KM'

EXEC sp_rename 'KMZD2005', 'KMZD'

EXEC sp_rename 'pzmain2005', 'pzmain'

EXEC sp_rename 'pzitem2005', 'pzitem'

EXEC sp_rename 'ztinfo2004', 'ztinfo'

EXEC sp_rename 'ZTXXCFG2004', 'ZTXXCFG'

EXEC sp_rename 'ZTperiod2004', 'ZTperiod'

EXEC sp_rename 'Tbrepinfor2004', 'Tbrepinfor'

EXEC sp_rename 'TPZ2004', 'TPZ'

EXEC sp_rename 'printFmt2004', 'printFmt'

EXEC sp_rename 'KM2004', 'KM'

EXEC sp_rename 'KMZD2004', 'KMZD'

EXEC sp_rename 'pzmain2004', 'pzmain'

EXEC sp_rename 'pzitem2004', 'pzitem'

EXEC sp_rename 'ztinfo2003', 'ztinfo'

EXEC sp_rename 'ZTXXCFG2003', 'ZTXXCFG'

EXEC sp_rename 'ZTperiod2003', 'ZTperiod'

EXEC sp_rename 'Tbrepinfor2003', 'Tbrepinfor'

EXEC sp_rename 'TPZ2003', 'TPZ'

EXEC sp_rename 'printFmt2003', 'printFmt'

EXEC sp_rename 'KM2003', 'KM'

EXEC sp_rename 'KMZD2003', 'KMZD'

EXEC sp_rename 'pzmain2003', 'pzmain'

EXEC sp_rename 'pzitem2003', 'pzitem'

EXEC sp_rename 'ztinfo2002', 'ztinfo'

EXEC sp_rename 'ZTXXCFG2002', 'ZTXXCFG'

EXEC sp_rename 'ZTperiod2002', 'ZTperiod'

EXEC sp_rename 'Tbrepinfor2002', 'Tbrepinfor'

EXEC sp_rename 'TPZ2002', 'TPZ'

EXEC sp_rename 'printFmt2002', 'printFmt'

EXEC sp_rename 'KM2002', 'KM'

EXEC sp_rename 'KMZD2002', 'KMZD'

EXEC sp_rename 'pzmain2002', 'pzmain'

EXEC sp_rename 'pzitem2002', 'pzitem'

EXEC sp_rename 'ztinfo2001', 'ztinfo'

EXEC sp_rename 'ZTXXCFG2001', 'ZTXXCFG'

EXEC sp_rename 'ZTperiod2001', 'ZTperiod'

EXEC sp_rename 'Tbrepinfor2001', 'Tbrepinfor'

EXEC sp_rename 'TPZ2001', 'TPZ'

EXEC sp_rename 'printFmt2001', 'printFmt'

EXEC sp_rename 'KM2001', 'KM'

EXEC sp_rename 'KMZD2001', 'KMZD'

EXEC sp_rename 'pzmain2001', 'pzmain'

EXEC sp_rename 'pzitem2001', 'pzitem'

EXEC sp_rename 'ztinfo2000', 'ztinfo'

EXEC sp_rename 'ZTXXCFG2000', 'ZTXXCFG'

EXEC sp_rename 'ZTperiod2000', 'ZTperiod'

EXEC sp_rename 'Tbrepinfor2000', 'Tbrepinfor'

EXEC sp_rename 'TPZ2000', 'TPZ'

EXEC sp_rename 'printFmt2000', 'printFmt'

EXEC sp_rename 'KM2000', 'KM'

EXEC sp_rename 'KMZD2000', 'KMZD'

EXEC sp_rename 'pzmain2000', 'pzmain'

EXEC sp_rename 'pzitem2000', 'pzitem'