U8表

--删除存货自由项对照表

delete from AA_InvFreeContrapose where cudvalue ='(150~750)双孔(800)'

 

编码规则表GradeDef

select GradeDef, * from GradeDef where KEYWORD='code'

update GradeDef  set CODINGRULE='42222' where KEYWORD='code'

 

存货档案辅表 select fInvCIQExch ,* from Inventory_Sub  where fInvCIQExch =1

update Inventory_Sub set fInvCIQExch=NULL where fInvCIQExch =1

 

编码规则表GradeDef

select GradeDef, * from GradeDef where KEYWORD='code'

update GradeDef  set CODINGRULE='42222' where KEYWORD='code'

 

 存货档案辅表 select fInvCIQExch ,* from Inventory_Sub  where fInvCIQExch =1

update Inventory_Sub set fInvCIQExch=NULL where fInvCIQExch =1

select * from Inventory

 

DELETE FROM Inventory

 

select * from Inventory_sub

 

DELETE FROM Inventory_sub

 

select * from  Inventory_extradefine

 

DELETE FROM Inventory_extradefine

转载于:https://www.cnblogs.com/passerlee/p/10013724.html