浪潮反年结

浪潮软件没有反年结功能..
只能复制个帐套恢复到上一年,
恢复语句仅供参考

if exists(select 1 from sysobjects where name='ZWTHPZ' and xtype='u')
    drop table    lc0029999.ZWTHPZ
if exists(select 1 from sysobjects where name='ZWHSQT' and xtype='u')
    drop table    lc0029999.ZWHSQT
if exists(select 1 from sysobjects where name='ZWHSXM' and xtype='u')
    drop table    lc0029999.ZWHSXM
if exists(select 1 from sysobjects where name='ZWTHYS' and xtype='u')
    drop table    lc0029999.ZWTHYS
if exists(select 1 from sysobjects where name='ZWTZLB' and xtype='u')
    drop table    lc0029999.ZWTZLB
if exists(select 1 from sysobjects where name='ZWTZXM' and xtype='u')
    drop table    lc0029999.ZWTZXM
if exists(select 1 from sysobjects where name='ZWTZYE' and xtype='u')
    drop table    lc0029999.ZWTZYE
if exists(select 1 from sysobjects where name='LSZBGS' and xtype='u')
    drop table    lc0029999.LSZBGS
if exists(select 1 from sysobjects where name='ZWWLDJ' and xtype='u')
    drop table    lc0029999.ZWWLDJ
if exists(select 1 from sysobjects where name='ZWHXJL' and xtype='u')
    drop table    lc0029999.ZWHXJL
if exists(select 1 from sysobjects where name='LSZRZC' and xtype='u')
    drop table    lc0029999.LSZRZC
if exists(select 1 from sysobjects where name='LSBMZD' and xtype='u')
    drop table    lc0029999.LSBMZD
if exists(select 1 from sysobjects where name='LSGDHL' and xtype='u')
    drop table    lc0029999.LSGDHL
if exists(select 1 from sysobjects where name='LSWBZD' and xtype='u')
    drop table    lc0029999.LSWBZD
if exists(select 1 from sysobjects where name='ZWWLDW' and xtype='u')
    drop table    lc0029999.ZWWLDW
if exists(select 1 from sysobjects where name='ZWJSFS' and xtype='u')
    drop table    lc0029999.ZWJSFS
if exists(select 1 from sysobjects where name='LSYJST' and xtype='u')
    drop table    lc0029999.LSYJST
if exists(select 1 from sysobjects where name='ZWWLQY' and xtype='u')
    drop table    lc0029999.ZWWLQY
if exists(select 1 from sysobjects where name='LSBJG' and xtype='u')
    drop table    lc0029999.LSBJG
if exists(select 1 from sysobjects where name='ZWXGKM' and xtype='u')
    drop table    lc0029999.ZWXGKM
if exists(select 1 from sysobjects where name='ZWJZJL' and xtype='u')
    drop table    lc0029999.ZWJZJL
if exists(select 1 from sysobjects where name='LSXXHL' and xtype='u')
    drop table    lc0029999.LSXXHL
if exists(select 1 from sysobjects where name='ZWXJDX' and xtype='u')
    drop table    lc0029999.ZWXJDX
if exists(select 1 from sysobjects where name='ZWKMFC' and xtype='u')
    drop table    lc0029999.ZWKMFC
if exists(select 1 from sysobjects where name='ZWKMJE' and xtype='u')
    drop table    lc0029999.ZWKMJE
if exists(select 1 from sysobjects where name='ZWBMZD_BASE' and xtype='u')
    drop table    lc0029999.ZWBMZD_BASE
if exists(select 1 from sysobjects where name='LSBMJG' and xtype='u')
    drop table    lc0029999.LSBMJG
if exists(select 1 from sysobjects where name='ZWXJJG' and xtype='u')
    drop table    lc0029999.ZWXJJG
if exists(select 1 from sysobjects where name='ZWDLCS' and xtype='u')
    drop table    lc0029999.ZWDLCS
if exists(select 1 from sysobjects where name='LSCOMN' and xtype='u')
    drop table    lc0029999.LSCOMN
if exists(select 1 from sysobjects where name='LSCONF' and xtype='u')
    drop table    lc0029999.LSCONF
if exists(select 1 from sysobjects where name='ZWXJKM' and xtype='u')
    drop table    lc0029999.ZWXJKM
if exists(select 1 from sysobjects where name='ZWDLLM' and xtype='u')
    drop table    lc0029999.ZWDLLM
if exists(select 1 from sysobjects where name='ZWDQZD' and xtype='u')
    drop table    lc0029999.ZWDQZD
if exists(select 1 from sysobjects where name='LSDYZD' and xtype='u')
    drop table    lc0029999.LSDYZD
if exists(select 1 from sysobjects where name='ZWXJLB' and xtype='u')
    drop table    lc0029999.ZWXJLB
if exists(select 1 from sysobjects where name='ZWKMJZ' and xtype='u')
    drop table    lc0029999.ZWKMJZ
if exists(select 1 from sysobjects where name='ZWDWLB' and xtype='u')
    drop table    lc0029999.ZWDWLB
if exists(select 1 from sysobjects where name='ZWXJXM' and xtype='u')
    drop table    lc0029999.ZWXJXM
if exists(select 1 from sysobjects where name='ZWKMSC' and xtype='u')
    drop table    lc0029999.ZWKMSC
if exists(select 1 from sysobjects where name='ZWDZQC' and xtype='u')
    drop table    lc0029999.ZWDZQC
if exists(select 1 from sysobjects where name='ZWXJYS' and xtype='u')
    drop table    lc0029999.ZWXJYS
if exists(select 1 from sysobjects where name='ZWKMSL' and xtype='u')
    drop table    lc0029999.ZWKMSL
if exists(select 1 from sysobjects where name='ZWXMGS' and xtype='u')
    drop table    lc0029999.ZWXMGS
if exists(select 1 from sysobjects where name='ZWDZZH' and xtype='u')
    drop table    lc0029999.ZWDZZH
if exists(select 1 from sysobjects where name='ZWXMJG' and xtype='u')
    drop table    lc0029999.ZWXMJG
if exists(select 1 from sysobjects where name='ZWKMSX' and xtype='u')
    drop table    lc0029999.ZWKMSX
if exists(select 1 from sysobjects where name='ZWXMLB' and xtype='u')
    drop table    lc0029999.ZWXMLB
if exists(select 1 from sysobjects where name='ZWFYMB' and xtype='u')
    drop table    lc0029999.ZWFYMB
if exists(select 1 from sysobjects where name='ZWKMWB' and xtype='u')
    drop table    lc0029999.ZWKMWB
if exists(select 1 from sysobjects where name='ZWYHJG' and xtype='u')
    drop table    lc0029999.ZWYHJG
if exists(select 1 from sysobjects where name='ZWFZFC' and xtype='u')
    drop table    lc0029999.ZWFZFC
if exists(select 1 from sysobjects where name='ZWFZJE' and xtype='u')
    drop table    lc0029999.ZWFZJE
if exists(select 1 from sysobjects where name='ZWYHZD' and xtype='u')
    drop table    lc0029999.ZWYHZD
if exists(select 1 from sysobjects where name='LSGNZD' and xtype='u')
    drop table    lc0029999.LSGNZD
if exists(select 1 from sysobjects where name='LSGRAN' and xtype='u')
    drop table    lc0029999.LSGRAN
if exists(select 1 from sysobjects where name='ZWYSLB' and xtype='u')
    drop table    lc0029999.ZWYSLB
if exists(select 1 from sysobjects where name='ZWFZLJ' and xtype='u')
    drop table    lc0029999.ZWFZLJ
if exists(select 1 from sysobjects where name='LSGRAP' and xtype='u')
    drop table    lc0029999.LSGRAP
if exists(select 1 from sysobjects where name='ZWYSLY' and xtype='u')
    drop table    lc0029999.ZWYSLY
if exists(select 1 from sysobjects where name='ZWYSPZ' and xtype='u')
    drop table    lc0029999.ZWYSPZ
if exists(select 1 from sysobjects where name='LSHELP' and xtype='u')
    drop table    lc0029999.LSHELP
if exists(select 1 from sysobjects where name='LSKJQJ' and xtype='u')
    drop table    lc0029999.LSKJQJ
if exists(select 1 from sysobjects where name='ZWKMZD' and xtype='u')
    drop table    lc0029999.ZWKMZD
if exists(select 1 from sysobjects where name='ZWFZSL' and xtype='u')
    drop table    lc0029999.ZWFZSL
if exists(select 1 from sysobjects where name='LSNBBM' and xtype='u')
    drop table    lc0029999.LSNBBM
if exists(select 1 from sysobjects where name='LSOTGS' and xtype='u')
    drop table    lc0029999.LSOTGS
if exists(select 1 from sysobjects where name='ZWYSXM' and xtype='u')
    drop table    lc0029999.ZWYSXM
if exists(select 1 from sysobjects where name='LSPASS' and xtype='u')
    drop table    lc0029999.LSPASS
if exists(select 1 from sysobjects where name='LSRECO' and xtype='u')
    drop table    lc0029999.LSRECO
if exists(select 1 from sysobjects where name='ZWYXMX' and xtype='u')
    drop table    lc0029999.ZWYXMX
if exists(select 1 from sysobjects where name='LSROGN' and xtype='u')
    drop table    lc0029999.LSROGN
if exists(select 1 from sysobjects where name='ZWFZWB' and xtype='u')
    drop table    lc0029999.ZWFZWB
if exists(select 1 from sysobjects where name='LSROLE' and xtype='u')
    drop table    lc0029999.LSROLE
if exists(select 1 from sysobjects where name='ZWZDFL' and xtype='u')
    drop table    lc0029999.ZWZDFL
if exists(select 1 from sysobjects where name='ZWZDGS' and xtype='u')
    drop table    lc0029999.ZWZDGS
if exists(select 1 from sysobjects where name='ZWZDJL' and xtype='u')
    drop table    lc0029999.ZWZDJL
if exists(select 1 from sysobjects where name='LSROSJ' and xtype='u')
    drop table    lc0029999.LSROSJ
if exists(select 1 from sysobjects where name='ZWZDPZ' and xtype='u')
    drop table    lc0029999.ZWZDPZ
if exists(select 1 from sysobjects where name='LSSCXT' and xtype='u')
    drop table    lc0029999.LSSCXT
if exists(select 1 from sysobjects where name='LSSTJG' and xtype='u')
    drop table    lc0029999.LSSTJG
if exists(select 1 from sysobjects where name='ZWZDSR' and xtype='u')
    drop table    lc0029999.ZWZDSR
if exists(select 1 from sysobjects where name='ZWZDYS' and xtype='u')
    drop table    lc0029999.ZWZDYS
if exists(select 1 from sysobjects where name='ZWKMZX' and xtype='u')
    drop table    lc0029999.ZWKMZX
if exists(select 1 from sysobjects where name='LSSTRU' and xtype='u')
    drop table    lc0029999.LSSTRU
if exists(select 1 from sysobjects where name='ZWZGDJ' and xtype='u')
    drop table    lc0029999.ZWZGDJ
if exists(select 1 from sysobjects where name='LSTABN' and xtype='u')
    drop table    lc0029999.LSTABN
if exists(select 1 from sysobjects where name='ZWMBMS' and xtype='u')
    drop table    lc0029999.ZWMBMS
if exists(select 1 from sysobjects where name='ZWPZBH' and xtype='u')
    drop table    lc0029999.ZWPZBH
if exists(select 1 from sysobjects where name='ZWPZFA' and xtype='u')
    drop table    lc0029999.ZWPZFA
if exists(select 1 from sysobjects where name='ZWPZFL' and xtype='u')
    drop table    lc0029999.ZWPZFL
if exists(select 1 from sysobjects where name='LSTIGS' and xtype='u')
    drop table    lc0029999.LSTIGS
if exists(select 1 from sysobjects where name='ZWZGHX' and xtype='u')
    drop table    lc0029999.ZWZGHX
if exists(select 1 from sysobjects where name='ZWFZYS' and xtype='u')
    drop table    lc0029999.ZWFZYS
if exists(select 1 from sysobjects where name='LSTJBB' and xtype='u')
    drop table    lc0029999.LSTJBB
if exists(select 1 from sysobjects where name='ZWPZGS' and xtype='u')
    drop table    lc0029999.ZWPZGS
if exists(select 1 from sysobjects where name='LSTJNR' and xtype='u')
    drop table    lc0029999.LSTJNR
if exists(select 1 from sysobjects where name='ZWPZK' and xtype='u')
    drop table    lc0029999.ZWPZK
if exists(select 1 from sysobjects where name='LSUSGN' and xtype='u')
    drop table    lc0029999.LSUSGN
if exists(select 1 from sysobjects where name='LSUSSJ' and xtype='u')
    drop table    lc0029999.LSUSSJ
if exists(select 1 from sysobjects where name='ZWZGQY' and xtype='u')
    drop table    lc0029999.ZWZGQY
if exists(select 1 from sysobjects where name='ZWFZZY' and xtype='u')
    drop table    lc0029999.ZWFZZY
if exists(select 1 from sysobjects where name='ZWZGZD' and xtype='u')
    drop table    lc0029999.ZWZGZD
if exists(select 1 from sysobjects where name='ZWPZLX' and xtype='u')
    drop table    lc0029999.ZWPZLX
if exists(select 1 from sysobjects where name='ZWZLQJ' and xtype='u')
    drop table    lc0029999.ZWZLQJ
if exists(select 1 from sysobjects where name='ZWZPZB' and xtype='u')
    drop table    lc0029999.ZWZPZB
if exists(select 1 from sysobjects where name='ZWPZMB' and xtype='u')
    drop table    lc0029999.ZWPZMB
if exists(select 1 from sysobjects where name='LSXTMC' and xtype='u')
    drop table    lc0029999.LSXTMC
if exists(select 1 from sysobjects where name='ZWRJQC' and xtype='u')
    drop table    lc0029999.ZWRJQC
if exists(select 1 from sysobjects where name='LSYMSZ' and xtype='u')
    drop table    lc0029999.LSYMSZ
if exists(select 1 from sysobjects where name='ZWRJZD' and xtype='u')
    drop table    lc0029999.ZWRJZD
if exists(select 1 from sysobjects where name='ZWSLCS' and xtype='u')
    drop table    lc0029999.ZWSLCS
if exists(select 1 from sysobjects where name='ZWSLML' and xtype='u')
    drop table    lc0029999.ZWSLML
if exists(select 1 from sysobjects where name='ZWTHMX' and xtype='u')
    drop table    lc0029999.ZWTHMX
if exists(select 1 from sysobjects where name='ZWHSDX' and xtype='u')
    drop table    lc0029999.ZWHSDX

SQL1

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'

posted @ 2015-06-05 12:59 鹄鹄阅读(921) 评论(0) 编辑收藏举报

向阳

.net b1 sap byd

浪潮反年结

向阳

.net b1 sap byd

浪潮 反年结

浪潮反年结