SQLServer定时执行SQL语句

2024年4月19日发(作者：)

dateadd(day,14,Add_date) as Add_date from nfo where Order_status=1 or Order_status=3

open pcurr

fetch next from pcurr into @Id,@Order_status,@FHTime,@Add_date

while (@@fetch_status = 0)

begin

if(@Order_status=3)

begin

if(@FHTime

begin

--print 'a'

update nfo set Order_status=4 where [Id]=@Id

end

end

else if(@Order_status=1)

begin

if(@Add_date

begin

--print 'b'

update nfo set Order_status=0 where [Id]=@Id

end

end

fetch next from pcurr into @Id,@Order_status,@FHTime,@Add_date

end

close pcurr

deallocate pcurr

exec [autoModify]