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

最新推荐文章于 2024-07-28 16:45:24 发布

u014461454

最新推荐文章于 2024-07-28 16:45:24 发布

阅读量6k

点赞数

分类专栏： SQLServer 文章标签： MSSQL 自动删除7天前数据

本文链接：https://blog.csdn.net/hawht/article/details/48285889

版权

SQLServer 专栏收录该内容

14 篇文章 0 订阅

订阅专栏

作用：
删除七天前数据库中间表的资料，并收缩数据库
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