Update column every 24 hours

Question

I have a column of values and I need it to update every 24 hours decreasing the maximum value by 1 until it reaches 0, and after that SQL will delete it. How could I do this on SQL Server?

What has your research show you? This is a frequently asked question. — Dale K, Sep 18 '20 at 02:40
The engine itself does not do this. You will need to _schedule_ (hint) something. — SMor, Sep 18 '20 at 02:45
https://stackoverflow.com/questions/40958990/update-record-inserted-in-table-after-one-hour — Dale K, Sep 18 '20 at 02:46
That was just the first result of my google search... there were loads... — Dale K, Sep 18 '20 at 03:11

score 1 · Answer 1 · edited Sep 18 '20 at 03:11

1

You can write a stored procedure that runs the code and schedule it using SQL Agent.

edited Sep 18 '20 at 03:11

Dale K

21,987
13
41
69

answered Sep 18 '20 at 03:04

luisvenezian

375
3
12

Update column every 24 hours

1 Answers1