SQL 自动清除7天前数据前收缩数据库

来源：互联网发布：ug8.0编程教程编辑：程序博客网时间：2024/06/09 20:09

作用：删除七天前数据库中间表的资料，并收缩数据库delete-Ecustom-xml-midtable.sql

delete Mid_bom where datediff(day,dty,getdate())>=7delete Mid_cus where datediff(day,dty,getdate())>=7delete Mid_exp where datediff(day,dty,getdate())>=7delete Mid_inv where datediff(day,dty,getdate())>=7delete Mid_itm where datediff(day,dty,getdate())>=7delete Mid_opi where datediff(day,dty,getdate())>=7delete Mid_opo where datediff(day,dty,getdate())>=7delete Mid_ord where datediff(day,dty,getdate())>=7delete Mid_pur where datediff(day,dty,getdate())>=7delete Mid_rec where datediff(day,dty,getdate())>=7delete Mid_stk where datediff(day,dty,getdate())>=7delete Mid_vdr where datediff(day,dty,getdate())>=7delete Mid_vla where datediff(day,dty,getdate())>=7delete Mid_wip where datediff(day,dty,getdate())>=7GODBCC SHRINKDATABASE(ECustomXML)GO

0 0