Use dateadd to delete data for a period of time

 

Dateadd

Returns the newDatetimeValue.

Syntax

Dateadd( Datepart, Number, Date)

Parameters

Example of deleting data a week ago: Select * From lgh_log where fact_date <dateadd (day,-7, getdate ())

ExploitationDateadd can automatically delete data for a period of time.

You can create a task, back up the task, and delete some of the content in the following task.

-- Deletes data from a week before the current time.

 

Begin transaction
Delete from tablename where date_time <dateadd (day,-7, getdate ())
If @ error! = 0
Begin
Rollback transaction
Return
End
Commit transaction