Delete rows automatically in a table

Question

I I want the rows where the EndDate column has passed today's date to be automatically removed from a table in SQLServer.

Answer 1

Hi LillaMy-9261,

Agree with others.
You can use SQL Server agent job and write a stored procedure that deletes every rows that date is passed today's date.
For example:

CREATE  PROCEDURE DeleteRows()  
AS  
BEGIN  
DELETE FROM Table  
WHERE DateColumn < GETDATE()  
END  

Please check Create a Job and Schedule a Job which might be helpful.

Best Regards,
Amelia

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

You would have to create a SQL Agent job to run every day to delete those records.

Answer 3

Any idea why the data of the EndDate column passed today's date have to be deleted? How do you check the historical data if you do? I would suggest to add a flag column to indicate those data, i.e., Is_Active = 0 or Is_Completed = 1.