حضرت خواجہ سیدنا معین الدین حسن چشتی سنجاری اجمیری رحمۃ اللہ علیہ

How to reset column value in SQL Server database automatically every year

pian

Hello, I have a LEAVE Request for an employee, and they only have 10 leaves. And after a year how to reset the records of leaves of an employee?

Mudassar

0 4

It is possible only with

1. Using a Windows Service.

2. SQL Job set to run on every yeat 1st JAN.