财贸双全清除系统冗余数据

最新推荐文章于 2024-10-06 20:16:20 发布

where happens

最新推荐文章于 2024-10-06 20:16:20 发布

阅读量209

点赞数 2

文章标签： java 前端数据库 linux javascript

本文链接：https://blog.csdn.net/TMise/article/details/137884245

版权

管家婆财贸双全清除冗余数据

delete from t_cw_dlyndx where draft<>2
delete from t_cw_dlyndx where vchcode not in (select vchcode from t_cw_dly)
TRUNCATE TABLE t_CW_bakdly
TRUNCATE TABLE t_cw_bakdlysup
--TRUNCATE TABLE  T_CW_Dlysup--(里面是支付方式，财务版本里面最好先确认下)
truncate table dlyndxmodify
truncate table dlymodify
delete a FROM T_CW_Atodini a 
	INNER JOIN AtypeCW b ON a.AtypeID = b.typeID
where checkdep = 0 and checkbtype = 0 and checketype = 0 and checkqty = 0 and checkclient = 0 and checkMtype = 0 --and CheckJtype = 0 
and CheckWaiBi = 0 and dtypeid = '' and btypeid = '' and etypeid = '' and clientid = '' and mtypeid = '' and qty=0


delete a  from  T_CW_Atodini a 
	INNER JOIN AtypeCW b ON a.AtypeID = b.typeID
where (checkdep = 0 and a.dtypeid<>'') or (checkbtype = 0 and btypeid <> '') or ( checketype = 0 and etypeid <> '' ) or ( checkqty = 0  and qty<>0) OR (checkclient = 0 and clientid <> '') or (checkMtype = 0 and mtypeid <> '') or ( CheckWaiBi = 0 and a.ForeignId<>0)