金蝶K3供应链反初始化SQL.docxVIP

第PAGE1页共NUMPAGES2页

金蝶K3软件物流反初始化的SQL语句

提醒:执行语句前一定要先备份账套!

以下为SQL语句具体内容:

Ifexists(select*fromsysobjectswherename=RestartSystemandtype=P)检查存储过程是否存在

DropprocedureRestartSystem????存在则删除之

Go

CreateProcedureRestartSystem定义存储过程

AS

Declare@StartPeriodint,

@startyearint,

@CurStartDatevarchar(20)

处理余额和即时库存数据

DeleteFromICBal

DeleteFromICInvBal

DeleteFromICInventory

DeleteFromICInvInitialWhereFPeriod0

取帐套启用时间

select@startyear=convert(int,FValue)fromt_SystemProfilewhereFCategory=icandFKey=startyear

select@startperiod=convert(int,FValue)fromt_SystemProfilewhere