如何删除MS SQL数据库中最旧的星期(句号)? [英] How to delete oldest week(period) in MS SQL database?
本文介绍了如何删除MS SQL数据库中最旧的星期(句号)?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
MS SQL 2008R2 Express,我有数据库-一个带行的表.当数据库大小变为约10GB时,我需要清理此表中最旧的一周(我不知道日期).您能帮我编写脚本吗?谢谢.
MS SQL 2008R2 Express, I have database - one table with rows. And when db size became about 10gb I need to clean one oldest week in this table (I dont know the date). Could you help me with script? Thanks.
UPD1. 有列DateAndTime,所以我在VBA中进行如下查询:
UPD1. There is column DateAndTime, so i make query like this in VBA:
strSQL = "SELECT DateAndTime
,TagName
,Val
,SetPoint
,Limit_H
,Limit_L
,Result
FROM dbo.Statistic
WHERE DateAndTime BETWEEN CAST('" & TimeBegin & "' AS datetime) AND CAST( '" & TimeEnd & " ' AS datetime)
Order By DateAndTime desc , (CASE WHEN ISNUMERIC(TagName)=1 THEN CAST(CAST(TagName AS float) AS INT)END ) desc"
推荐答案
这是怎么回事-
DELETE YOUR_TABLE
WHERE DATE_COL BETWEEN (SELECT MIN(DATE) FROM YOUR_TABLE) AND (SELECT MIN(DATE) FROM YOUR_TABLE) + 7
这篇关于如何删除MS SQL数据库中最旧的星期(句号)?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文