如何在SQL Server中删除所有创建时间晚于10分钟的行?谢谢。
DELETE FROM Table_name
WHERE Date_column < DATEADD(mi,-10,GETDATE())
time_created
是从哪里来的? - Trinimonmodified
。CREATE TRIGGER dbo.trigger_table_update
ON dbo.MyTable AFTER UPDATE
AS BEGIN
UPDATE dbo.MyTable SET modified = GETDATE()
FROM INSERTED i
WHERE dbo.MyTable.ID = i.ID
END
DELETE FROM MyTable
WHERE modified < DATEADD(mm,-10,GETDATE())
SQL Server无法确定行创建的时间。您需要在表中添加一个额外的列来记录时间。如果这样做,您的删除语句将变得非常简单。
WHERE DATEDIFF(MINUTE, order.credat, CURRENT_TIMESTAMP) < 10