Friday, January 13, 2023

SQL Server - Auto Delete

Auto Deletion


There are Many Causes for fraudulent calls we receive intermittently.


However, there are some automation which can be implemented in order to delete these call records.



delete from call_records where [from]='Other Agency'




The above query syntax can also be automated through SQL Agent Jobs and scheduled to run on daily basis.


Best Regards


Amit Vaid

No comments: