浪潮软件没有反年结功能..
只能复制个帐套恢复到上一年,恢复语句仅供参考
if exists(select 1 from sysobjects where name='ZWTHPZ' and xtype='u') drop table lc0029999.ZWTHPZif exists(select 1 from sysobjects where name='ZWHSQT' and xtype='u') drop table lc0029999.ZWHSQTif exists(select 1 from sysobjects where name='ZWHSXM' and xtype='u') drop table lc0029999.ZWHSXMif exists(select 1 from sysobjects where name='ZWTHYS' and xtype='u') drop table lc0029999.ZWTHYSif exists(select 1 from sysobjects where name='ZWTZLB' and xtype='u') drop table lc0029999.ZWTZLBif exists(select 1 from sysobjects where name='ZWTZXM' and xtype='u') drop table lc0029999.ZWTZXMif exists(select 1 from sysobjects where name='ZWTZYE' and xtype='u') drop table lc0029999.ZWTZYEif exists(select 1 from sysobjects where name='LSZBGS' and xtype='u') drop table lc0029999.LSZBGSif exists(select 1 from sysobjects where name='ZWWLDJ' and xtype='u') drop table lc0029999.ZWWLDJif exists(select 1 from sysobjects where name='ZWHXJL' and xtype='u') drop table lc0029999.ZWHXJLif exists(select 1 from sysobjects where name='LSZRZC' and xtype='u') drop table lc0029999.LSZRZCif exists(select 1 from sysobjects where name='LSBMZD' and xtype='u') drop table lc0029999.LSBMZDif exists(select 1 from sysobjects where name='LSGDHL' and xtype='u') drop table lc0029999.LSGDHLif exists(select 1 from sysobjects where name='LSWBZD' and xtype='u') drop table lc0029999.LSWBZDif exists(select 1 from sysobjects where name='ZWWLDW' and xtype='u') drop table lc0029999.ZWWLDWif exists(select 1 from sysobjects where name='ZWJSFS' and xtype='u') drop table lc0029999.ZWJSFSif exists(select 1 from sysobjects where name='LSYJST' and xtype='u') drop table lc0029999.LSYJSTif exists(select 1 from sysobjects where name='ZWWLQY' and xtype='u') drop table lc0029999.ZWWLQYif exists(select 1 from sysobjects where name='LSBJG' and xtype='u') drop table lc0029999.LSBJGif exists(select 1 from sysobjects where name='ZWXGKM' and xtype='u') drop table lc0029999.ZWXGKMif exists(select 1 from sysobjects where name='ZWJZJL' and xtype='u') drop table lc0029999.ZWJZJLif exists(select 1 from sysobjects where name='LSXXHL' and xtype='u') drop table lc0029999.LSXXHLif exists(select 1 from sysobjects where name='ZWXJDX' and xtype='u') drop table lc0029999.ZWXJDXif exists(select 1 from sysobjects where name='ZWKMFC' and xtype='u') drop table lc0029999.ZWKMFCif exists(select 1 from sysobjects where name='ZWKMJE' and xtype='u') drop table lc0029999.ZWKMJEif exists(select 1 from sysobjects where name='ZWBMZD_BASE' and xtype='u') drop table lc0029999.ZWBMZD_BASEif exists(select 1 from sysobjects where name='LSBMJG' and xtype='u') drop table lc0029999.LSBMJGif exists(select 1 from sysobjects where name='ZWXJJG' and xtype='u') drop table lc0029999.ZWXJJGif exists(select 1 from sysobjects where name='ZWDLCS' and xtype='u') drop table lc0029999.ZWDLCSif exists(select 1 from sysobjects where name='LSCOMN' and xtype='u') drop table lc0029999.LSCOMNif exists(select 1 from sysobjects where name='LSCONF' and xtype='u') drop table lc0029999.LSCONFif exists(select 1 from sysobjects where name='ZWXJKM' and xtype='u') drop table lc0029999.ZWXJKMif exists(select 1 from sysobjects where name='ZWDLLM' and xtype='u') drop table lc0029999.ZWDLLMif exists(select 1 from sysobjects where name='ZWDQZD' and xtype='u') drop table lc0029999.ZWDQZDif exists(select 1 from sysobjects where name='LSDYZD' and xtype='u') drop table lc0029999.LSDYZDif exists(select 1 from sysobjects where name='ZWXJLB' and xtype='u') drop table lc0029999.ZWXJLBif exists(select 1 from sysobjects where name='ZWKMJZ' and xtype='u') drop table lc0029999.ZWKMJZif exists(select 1 from sysobjects where name='ZWDWLB' and xtype='u') drop table lc0029999.ZWDWLBif exists(select 1 from sysobjects where name='ZWXJXM' and xtype='u') drop table lc0029999.ZWXJXMif exists(select 1 from sysobjects where name='ZWKMSC' and xtype='u') drop table lc0029999.ZWKMSCif exists(select 1 from sysobjects where name='ZWDZQC' and xtype='u') drop table lc0029999.ZWDZQCif exists(select 1 from sysobjects where name='ZWXJYS' and xtype='u') drop table lc0029999.ZWXJYSif exists(select 1 from sysobjects where name='ZWKMSL' and xtype='u') drop table lc0029999.ZWKMSLif exists(select 1 from sysobjects where name='ZWXMGS' and xtype='u') drop table lc0029999.ZWXMGSif exists(select 1 from sysobjects where name='ZWDZZH' and xtype='u') drop table lc0029999.ZWDZZHif exists(select 1 from sysobjects where name='ZWXMJG' and xtype='u') drop table lc0029999.ZWXMJGif exists(select 1 from sysobjects where name='ZWKMSX' and xtype='u') drop table lc0029999.ZWKMSXif exists(select 1 from sysobjects where name='ZWXMLB' and xtype='u') drop table lc0029999.ZWXMLBif exists(select 1 from sysobjects where name='ZWFYMB' and xtype='u') drop table lc0029999.ZWFYMBif exists(select 1 from sysobjects where name='ZWKMWB' and xtype='u') drop table lc0029999.ZWKMWBif exists(select 1 from sysobjects where name='ZWYHJG' and xtype='u') drop table lc0029999.ZWYHJGif exists(select 1 from sysobjects where name='ZWFZFC' and xtype='u') drop table lc0029999.ZWFZFCif exists(select 1 from sysobjects where name='ZWFZJE' and xtype='u') drop table lc0029999.ZWFZJEif exists(select 1 from sysobjects where name='ZWYHZD' and xtype='u') drop table lc0029999.ZWYHZDif exists(select 1 from sysobjects where name='LSGNZD' and xtype='u') drop table lc0029999.LSGNZDif exists(select 1 from sysobjects where name='LSGRAN' and xtype='u') drop table lc0029999.LSGRANif exists(select 1 from sysobjects where name='ZWYSLB' and xtype='u') drop table lc0029999.ZWYSLBif exists(select 1 from sysobjects where name='ZWFZLJ' and xtype='u') drop table lc0029999.ZWFZLJif exists(select 1 from sysobjects where name='LSGRAP' and xtype='u') drop table lc0029999.LSGRAPif exists(select 1 from sysobjects where name='ZWYSLY' and xtype='u') drop table lc0029999.ZWYSLYif exists(select 1 from sysobjects where name='ZWYSPZ' and xtype='u') drop table lc0029999.ZWYSPZif exists(select 1 from sysobjects where name='LSHELP' and xtype='u') drop table lc0029999.LSHELPif exists(select 1 from sysobjects where name='LSKJQJ' and xtype='u') drop table lc0029999.LSKJQJif exists(select 1 from sysobjects where name='ZWKMZD' and xtype='u') drop table lc0029999.ZWKMZDif exists(select 1 from sysobjects where name='ZWFZSL' and xtype='u') drop table lc0029999.ZWFZSLif exists(select 1 from sysobjects where name='LSNBBM' and xtype='u') drop table lc0029999.LSNBBMif exists(select 1 from sysobjects where name='LSOTGS' and xtype='u') drop table lc0029999.LSOTGSif exists(select 1 from sysobjects where name='ZWYSXM' and xtype='u') drop table lc0029999.ZWYSXMif exists(select 1 from sysobjects where name='LSPASS' and xtype='u') drop table lc0029999.LSPASSif exists(select 1 from sysobjects where name='LSRECO' and xtype='u') drop table lc0029999.LSRECOif exists(select 1 from sysobjects where name='ZWYXMX' and xtype='u') drop table lc0029999.ZWYXMXif exists(select 1 from sysobjects where name='LSROGN' and xtype='u') drop table lc0029999.LSROGNif exists(select 1 from sysobjects where name='ZWFZWB' and xtype='u') drop table lc0029999.ZWFZWBif exists(select 1 from sysobjects where name='LSROLE' and xtype='u') drop table lc0029999.LSROLEif exists(select 1 from sysobjects where name='ZWZDFL' and xtype='u') drop table lc0029999.ZWZDFLif exists(select 1 from sysobjects where name='ZWZDGS' and xtype='u') drop table lc0029999.ZWZDGSif exists(select 1 from sysobjects where name='ZWZDJL' and xtype='u') drop table lc0029999.ZWZDJLif exists(select 1 from sysobjects where name='LSROSJ' and xtype='u') drop table lc0029999.LSROSJif exists(select 1 from sysobjects where name='ZWZDPZ' and xtype='u') drop table lc0029999.ZWZDPZif exists(select 1 from sysobjects where name='LSSCXT' and xtype='u') drop table lc0029999.LSSCXTif exists(select 1 from sysobjects where name='LSSTJG' and xtype='u') drop table lc0029999.LSSTJGif exists(select 1 from sysobjects where name='ZWZDSR' and xtype='u') drop table lc0029999.ZWZDSRif exists(select 1 from sysobjects where name='ZWZDYS' and xtype='u') drop table lc0029999.ZWZDYSif exists(select 1 from sysobjects where name='ZWKMZX' and xtype='u') drop table lc0029999.ZWKMZXif exists(select 1 from sysobjects where name='LSSTRU' and xtype='u') drop table lc0029999.LSSTRUif exists(select 1 from sysobjects where name='ZWZGDJ' and xtype='u') drop table lc0029999.ZWZGDJif exists(select 1 from sysobjects where name='LSTABN' and xtype='u') drop table lc0029999.LSTABNif exists(select 1 from sysobjects where name='ZWMBMS' and xtype='u') drop table lc0029999.ZWMBMSif exists(select 1 from sysobjects where name='ZWPZBH' and xtype='u') drop table lc0029999.ZWPZBHif exists(select 1 from sysobjects where name='ZWPZFA' and xtype='u') drop table lc0029999.ZWPZFAif exists(select 1 from sysobjects where name='ZWPZFL' and xtype='u') drop table lc0029999.ZWPZFLif exists(select 1 from sysobjects where name='LSTIGS' and xtype='u') drop table lc0029999.LSTIGSif exists(select 1 from sysobjects where name='ZWZGHX' and xtype='u') drop table lc0029999.ZWZGHXif exists(select 1 from sysobjects where name='ZWFZYS' and xtype='u') drop table lc0029999.ZWFZYSif exists(select 1 from sysobjects where name='LSTJBB' and xtype='u') drop table lc0029999.LSTJBBif exists(select 1 from sysobjects where name='ZWPZGS' and xtype='u') drop table lc0029999.ZWPZGSif exists(select 1 from sysobjects where name='LSTJNR' and xtype='u') drop table lc0029999.LSTJNRif exists(select 1 from sysobjects where name='ZWPZK' and xtype='u') drop table lc0029999.ZWPZKif exists(select 1 from sysobjects where name='LSUSGN' and xtype='u') drop table lc0029999.LSUSGNif exists(select 1 from sysobjects where name='LSUSSJ' and xtype='u') drop table lc0029999.LSUSSJif exists(select 1 from sysobjects where name='ZWZGQY' and xtype='u') drop table lc0029999.ZWZGQYif exists(select 1 from sysobjects where name='ZWFZZY' and xtype='u') drop table lc0029999.ZWFZZYif exists(select 1 from sysobjects where name='ZWZGZD' and xtype='u') drop table lc0029999.ZWZGZDif exists(select 1 from sysobjects where name='ZWPZLX' and xtype='u') drop table lc0029999.ZWPZLXif exists(select 1 from sysobjects where name='ZWZLQJ' and xtype='u') drop table lc0029999.ZWZLQJif exists(select 1 from sysobjects where name='ZWZPZB' and xtype='u') drop table lc0029999.ZWZPZBif exists(select 1 from sysobjects where name='ZWPZMB' and xtype='u') drop table lc0029999.ZWPZMBif exists(select 1 from sysobjects where name='LSXTMC' and xtype='u') drop table lc0029999.LSXTMCif exists(select 1 from sysobjects where name='ZWRJQC' and xtype='u') drop table lc0029999.ZWRJQCif exists(select 1 from sysobjects where name='LSYMSZ' and xtype='u') drop table lc0029999.LSYMSZif exists(select 1 from sysobjects where name='ZWRJZD' and xtype='u') drop table lc0029999.ZWRJZDif exists(select 1 from sysobjects where name='ZWSLCS' and xtype='u') drop table lc0029999.ZWSLCSif exists(select 1 from sysobjects where name='ZWSLML' and xtype='u') drop table lc0029999.ZWSLMLif exists(select 1 from sysobjects where name='ZWTHMX' and xtype='u') drop table lc0029999.ZWTHMXif exists(select 1 from sysobjects where name='ZWHSDX' and xtype='u') drop table lc0029999.ZWHSDX
if exists(select 1 from sysobjects where name='ZWTHPZ2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWTHPZ2014','ZWTHPZ'if exists(select 1 from sysobjects where name='ZWHSQT2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWHSQT2014','ZWHSQT'if exists(select 1 from sysobjects where name='ZWHSXM2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWHSXM2014','ZWHSXM'if exists(select 1 from sysobjects where name='ZWTHYS2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWTHYS2014','ZWTHYS'if exists(select 1 from sysobjects where name='ZWTZLB2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWTZLB2014','ZWTZLB'if exists(select 1 from sysobjects where name='ZWTZXM2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWTZXM2014','ZWTZXM'if exists(select 1 from sysobjects where name='ZWTZYE2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWTZYE2014','ZWTZYE'if exists(select 1 from sysobjects where name='LSZBGS2014' and xtype='u') EXEC sp_rename 'lc0029999.LSZBGS2014','LSZBGS'if exists(select 1 from sysobjects where name='ZWWLDJ2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWWLDJ2014','ZWWLDJ'if exists(select 1 from sysobjects where name='ZWHXJL2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWHXJL2014','ZWHXJL'if exists(select 1 from sysobjects where name='LSZRZC2014' and xtype='u') EXEC sp_rename 'lc0029999.LSZRZC2014','LSZRZC'if exists(select 1 from sysobjects where name='LSBMZD2014' and xtype='u') EXEC sp_rename 'lc0029999.LSBMZD2014','LSBMZD'if exists(select 1 from sysobjects where name='LSGDHL2014' and xtype='u') EXEC sp_rename 'lc0029999.LSGDHL2014','LSGDHL'if exists(select 1 from sysobjects where name='LSWBZD2014' and xtype='u') EXEC sp_rename 'lc0029999.LSWBZD2014','LSWBZD'if exists(select 1 from sysobjects where name='ZWWLDW2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWWLDW2014','ZWWLDW'if exists(select 1 from sysobjects where name='ZWJSFS2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWJSFS2014','ZWJSFS'if exists(select 1 from sysobjects where name='LSYJST2014' and xtype='u') EXEC sp_rename 'lc0029999.LSYJST2014','LSYJST'if exists(select 1 from sysobjects where name='ZWWLQY2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWWLQY2014','ZWWLQY'if exists(select 1 from sysobjects where name='LSBJG2014' and xtype='u') EXEC sp_rename 'lc0029999.LSBJG2014','LSBJG'if exists(select 1 from sysobjects where name='ZWXGKM2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWXGKM2014','ZWXGKM'if exists(select 1 from sysobjects where name='ZWJZJL2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWJZJL2014','ZWJZJL'if exists(select 1 from sysobjects where name='LSXXHL2014' and xtype='u') EXEC sp_rename 'lc0029999.LSXXHL2014','LSXXHL'if exists(select 1 from sysobjects where name='ZWXJDX2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWXJDX2014','ZWXJDX'if exists(select 1 from sysobjects where name='ZWKMFC2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWKMFC2014','ZWKMFC'if exists(select 1 from sysobjects where name='ZWKMJE2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWKMJE2014','ZWKMJE'if exists(select 1 from sysobjects where name='ZWBMZD_BASE2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWBMZD_BASE2014','ZWBMZD_BASE'if exists(select 1 from sysobjects where name='LSBMJG2014' and xtype='u') EXEC sp_rename 'lc0029999.LSBMJG2014','LSBMJG'if exists(select 1 from sysobjects where name='ZWXJJG2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWXJJG2014','ZWXJJG'if exists(select 1 from sysobjects where name='ZWDLCS2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWDLCS2014','ZWDLCS'if exists(select 1 from sysobjects where name='LSCOMN2014' and xtype='u') EXEC sp_rename 'lc0029999.LSCOMN2014','LSCOMN'if exists(select 1 from sysobjects where name='LSCONF2014' and xtype='u') EXEC sp_rename 'lc0029999.LSCONF2014','LSCONF'if exists(select 1 from sysobjects where name='ZWXJKM2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWXJKM2014','ZWXJKM'if exists(select 1 from sysobjects where name='ZWDLLM2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWDLLM2014','ZWDLLM'if exists(select 1 from sysobjects where name='ZWDQZD2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWDQZD2014','ZWDQZD'if exists(select 1 from sysobjects where name='LSDYZD2014' and xtype='u') EXEC sp_rename 'lc0029999.LSDYZD2014','LSDYZD'if exists(select 1 from sysobjects where name='ZWXJLB2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWXJLB2014','ZWXJLB'if exists(select 1 from sysobjects where name='ZWKMJZ2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWKMJZ2014','ZWKMJZ'if exists(select 1 from sysobjects where name='ZWDWLB2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWDWLB2014','ZWDWLB'if exists(select 1 from sysobjects where name='ZWXJXM2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWXJXM2014','ZWXJXM'if exists(select 1 from sysobjects where name='ZWKMSC2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWKMSC2014','ZWKMSC'if exists(select 1 from sysobjects where name='ZWDZQC2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWDZQC2014','ZWDZQC'if exists(select 1 from sysobjects where name='ZWXJYS2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWXJYS2014','ZWXJYS'if exists(select 1 from sysobjects where name='ZWKMSL2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWKMSL2014','ZWKMSL'if exists(select 1 from sysobjects where name='ZWXMGS2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWXMGS2014','ZWXMGS'if exists(select 1 from sysobjects where name='ZWDZZH2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWDZZH2014','ZWDZZH'if exists(select 1 from sysobjects where name='ZWXMJG2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWXMJG2014','ZWXMJG'if exists(select 1 from sysobjects where name='ZWKMSX2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWKMSX2014','ZWKMSX'if exists(select 1 from sysobjects where name='ZWXMLB2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWXMLB2014','ZWXMLB'if exists(select 1 from sysobjects where name='ZWFYMB2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWFYMB2014','ZWFYMB'if exists(select 1 from sysobjects where name='ZWKMWB2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWKMWB2014','ZWKMWB'if exists(select 1 from sysobjects where name='ZWYHJG2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWYHJG2014','ZWYHJG'if exists(select 1 from sysobjects where name='ZWFZFC2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWFZFC2014','ZWFZFC'if exists(select 1 from sysobjects where name='ZWFZJE2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWFZJE2014','ZWFZJE'if exists(select 1 from sysobjects where name='ZWYHZD2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWYHZD2014','ZWYHZD'if exists(select 1 from sysobjects where name='LSGNZD2014' and xtype='u') EXEC sp_rename 'lc0029999.LSGNZD2014','LSGNZD'if exists(select 1 from sysobjects where name='LSGRAN2014' and xtype='u') EXEC sp_rename 'lc0029999.LSGRAN2014','LSGRAN'if exists(select 1 from sysobjects where name='ZWYSLB2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWYSLB2014','ZWYSLB'if exists(select 1 from sysobjects where name='ZWFZLJ2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWFZLJ2014','ZWFZLJ'if exists(select 1 from sysobjects where name='LSGRAP2014' and xtype='u') EXEC sp_rename 'lc0029999.LSGRAP2014','LSGRAP'if exists(select 1 from sysobjects where name='ZWYSLY2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWYSLY2014','ZWYSLY'if exists(select 1 from sysobjects where name='ZWYSPZ2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWYSPZ2014','ZWYSPZ'if exists(select 1 from sysobjects where name='LSHELP2014' and xtype='u') EXEC sp_rename 'lc0029999.LSHELP2014','LSHELP'if exists(select 1 from sysobjects where name='LSKJQJ2014' and xtype='u') EXEC sp_rename 'lc0029999.LSKJQJ2014','LSKJQJ'if exists(select 1 from sysobjects where name='ZWKMZD2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWKMZD2014','ZWKMZD'if exists(select 1 from sysobjects where name='ZWFZSL2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWFZSL2014','ZWFZSL'if exists(select 1 from sysobjects where name='LSNBBM2014' and xtype='u') EXEC sp_rename 'lc0029999.LSNBBM2014','LSNBBM'if exists(select 1 from sysobjects where name='LSOTGS2014' and xtype='u') EXEC sp_rename 'lc0029999.LSOTGS2014','LSOTGS'if exists(select 1 from sysobjects where name='ZWYSXM2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWYSXM2014','ZWYSXM'if exists(select 1 from sysobjects where name='LSPASS2014' and xtype='u') EXEC sp_rename 'lc0029999.LSPASS2014','LSPASS'if exists(select 1 from sysobjects where name='LSRECO2014' and xtype='u') EXEC sp_rename 'lc0029999.LSRECO2014','LSRECO'if exists(select 1 from sysobjects where name='ZWYXMX2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWYXMX2014','ZWYXMX'if exists(select 1 from sysobjects where name='LSROGN2014' and xtype='u') EXEC sp_rename 'lc0029999.LSROGN2014','LSROGN'if exists(select 1 from sysobjects where name='ZWFZWB2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWFZWB2014','ZWFZWB'if exists(select 1 from sysobjects where name='LSROLE2014' and xtype='u') EXEC sp_rename 'lc0029999.LSROLE2014','LSROLE'if exists(select 1 from sysobjects where name='ZWZDFL2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWZDFL2014','ZWZDFL'if exists(select 1 from sysobjects where name='ZWZDGS2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWZDGS2014','ZWZDGS'if exists(select 1 from sysobjects where name='ZWZDJL2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWZDJL2014','ZWZDJL'if exists(select 1 from sysobjects where name='LSROSJ2014' and xtype='u') EXEC sp_rename 'lc0029999.LSROSJ2014','LSROSJ'if exists(select 1 from sysobjects where name='ZWZDPZ2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWZDPZ2014','ZWZDPZ'if exists(select 1 from sysobjects where name='LSSCXT2014' and xtype='u') EXEC sp_rename 'lc0029999.LSSCXT2014','LSSCXT'if exists(select 1 from sysobjects where name='LSSTJG2014' and xtype='u') EXEC sp_rename 'lc0029999.LSSTJG2014','LSSTJG'if exists(select 1 from sysobjects where name='ZWZDSR2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWZDSR2014','ZWZDSR'if exists(select 1 from sysobjects where name='ZWZDYS2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWZDYS2014','ZWZDYS'if exists(select 1 from sysobjects where name='ZWKMZX2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWKMZX2014','ZWKMZX'if exists(select 1 from sysobjects where name='LSSTRU2014' and xtype='u') EXEC sp_rename 'lc0029999.LSSTRU2014','LSSTRU'if exists(select 1 from sysobjects where name='ZWZGDJ2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWZGDJ2014','ZWZGDJ'if exists(select 1 from sysobjects where name='LSTABN2014' and xtype='u') EXEC sp_rename 'lc0029999.LSTABN2014','LSTABN'if exists(select 1 from sysobjects where name='ZWMBMS2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWMBMS2014','ZWMBMS'if exists(select 1 from sysobjects where name='ZWPZBH2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWPZBH2014','ZWPZBH'if exists(select 1 from sysobjects where name='ZWPZFA2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWPZFA2014','ZWPZFA'if exists(select 1 from sysobjects where name='ZWPZFL2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWPZFL2014','ZWPZFL'if exists(select 1 from sysobjects where name='LSTIGS2014' and xtype='u') EXEC sp_rename 'lc0029999.LSTIGS2014','LSTIGS'if exists(select 1 from sysobjects where name='ZWZGHX2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWZGHX2014','ZWZGHX'if exists(select 1 from sysobjects where name='ZWFZYS2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWFZYS2014','ZWFZYS'if exists(select 1 from sysobjects where name='LSTJBB2014' and xtype='u') EXEC sp_rename 'lc0029999.LSTJBB2014','LSTJBB'if exists(select 1 from sysobjects where name='ZWPZGS2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWPZGS2014','ZWPZGS'if exists(select 1 from sysobjects where name='LSTJNR2014' and xtype='u') EXEC sp_rename 'lc0029999.LSTJNR2014','LSTJNR'if exists(select 1 from sysobjects where name='ZWPZK2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWPZK2014','ZWPZK'if exists(select 1 from sysobjects where name='LSUSGN2014' and xtype='u') EXEC sp_rename 'lc0029999.LSUSGN2014','LSUSGN'if exists(select 1 from sysobjects where name='LSUSSJ2014' and xtype='u') EXEC sp_rename 'lc0029999.LSUSSJ2014','LSUSSJ'if exists(select 1 from sysobjects where name='ZWZGQY2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWZGQY2014','ZWZGQY'if exists(select 1 from sysobjects where name='ZWFZZY2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWFZZY2014','ZWFZZY'if exists(select 1 from sysobjects where name='ZWZGZD2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWZGZD2014','ZWZGZD'if exists(select 1 from sysobjects where name='ZWPZLX2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWPZLX2014','ZWPZLX'if exists(select 1 from sysobjects where name='ZWZLQJ2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWZLQJ2014','ZWZLQJ'if exists(select 1 from sysobjects where name='ZWZPZB2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWZPZB2014','ZWZPZB'if exists(select 1 from sysobjects where name='ZWPZMB2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWPZMB2014','ZWPZMB'if exists(select 1 from sysobjects where name='LSXTMC2014' and xtype='u') EXEC sp_rename 'lc0029999.LSXTMC2014','LSXTMC'if exists(select 1 from sysobjects where name='ZWRJQC2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWRJQC2014','ZWRJQC'if exists(select 1 from sysobjects where name='LSYMSZ2014' and xtype='u') EXEC sp_rename 'lc0029999.LSYMSZ2014','LSYMSZ'if exists(select 1 from sysobjects where name='ZWRJZD2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWRJZD2014','ZWRJZD'if exists(select 1 from sysobjects where name='ZWSLCS2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWSLCS2014','ZWSLCS'if exists(select 1 from sysobjects where name='ZWSLML2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWSLML2014','ZWSLML'if exists(select 1 from sysobjects where name='ZWTHMX2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWTHMX2014','ZWTHMX'if exists(select 1 from sysobjects where name='ZWHSDX2014' and xtype='u') EXEC sp_rename 'lc0029999.ZWHSDX2014','ZWHSDX'