作用：
刪除七天前數據庫中間表的資料，并收縮數據庫
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文章來源：http://www.zghlxwxcb.cn/news/detail-651665.html
原文鏈接：https://blog.csdn.net/hawht/article/details/48285889文章來源地址http://www.zghlxwxcb.cn/news/detail-651665.html
到了這里，關于SQL 自動清除7天前數據前收縮數據庫的文章就介紹完了。如果您還想了解更多內容，請在右上角搜索TOY模板網以前的文章或繼續(xù)瀏覽下面的相關文章，希望大家以后多多支持TOY模板網！
