浪潮 反年结

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

复制代码
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
复制代码

 

  

posted @   鹄鹄  阅读(939)  评论(0编辑  收藏  举报
编辑推荐:
· 深入理解 Mybatis 分库分表执行原理
· 如何打造一个高并发系统?
· .NET Core GC压缩(compact_phase)底层原理浅谈
· 现代计算机视觉入门之:什么是图片特征编码
· .NET 9 new features-C#13新的锁类型和语义
阅读排行:
· Spring AI + Ollama 实现 deepseek-r1 的API服务和调用
· 《HelloGitHub》第 106 期
· 数据库服务器 SQL Server 版本升级公告
· 深入理解Mybatis分库分表执行原理
· 使用 Dify + LLM 构建精确任务处理应用
点击右上角即可分享
微信分享提示