Question

ASP 如何定时删除数据

每隔30分钟删除数据

（数据库类型SQL）

Answer 1

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

Answer 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