ASP 如何定时删除数据

每隔30分钟删除数据(数据库类型SQL)
2024-12-02 10:37:53
推荐回答(2个)
回答1:

conn.execute("delete from 表 where datediff(d,sj,'"&now()&"')>1")

回答2:

DECLARE @pid int(4)
---delete 10~19
SET @pid = '1%'

user table1
go
waitfor delay '00:30:00'
delete from table1 where id like @pid
go