Create procedure XXX
@day int--天数
as
declare @date date--定义一个时间变量
set @date=DATEADD(dd,-@day,GETDATE())--当前时间减去天数得到的时间
begin
delete from xx where xx<=@date
end
with list as
(
select * from xx
where xx=" "
)
select * from list
where (DATEDIFF(mi,时间字段,GETDATE())>120 )其意思:时间字段到当前时间超过120分钟