作用:
删除七天前数据库中间表的资料,并收缩数据库
delete-Ecustom-xml-midtable.sql
delete Mid_bom where datediff(day,dty,getdate())>=7
delete Mid_cus where datediff(day,dty,getdate())>=7
delete Mid_exp where datediff(day,dty,getdate())>=7
delete Mid_inv where datediff(day,dty,getdate())>=7
delete Mid_itm where datediff(day,dty,getdate())>=7
delete Mid_opi where datediff(day,dty,getdate())>=7
delete Mid_opo where datediff(day,dty,getdate())>=7
delete Mid_ord where datediff(day,dty,getdate())>=7
delete Mid_pur where datediff(day,dty,getdate())>=7
delete Mid_rec where datediff(day,dty,getdate())>=7
delete Mid_stk where datediff(day,dty,getdate())>=7
delete Mid_vdr where datediff(day,dty,getdate())>=7
delete Mid_vla where datediff(day,dty,getdate())>=7
delete Mid_wip where datediff(day,dty,getdate())>=7
GO
DBCC SHRINKDATABASE(ECustomXML)
GO文章来源:https://www.toymoban.com/news/detail-651665.html
原文链接:https://blog.csdn.net/hawht/article/details/48285889文章来源地址https://www.toymoban.com/news/detail-651665.html
到了这里,关于SQL 自动清除7天前数据前收缩数据库的文章就介绍完了。如果您还想了解更多内容,请在右上角搜索TOY模板网以前的文章或继续浏览下面的相关文章,希望大家以后多多支持TOY模板网!