I have an ASP.NET application, that uses SQL Server as backend.
Now I have developed a form where the user enters the details, and he selects a date and submits. But the submitted data will be updated on the day the user selected the date.
So I was wondering if I can create SQL Trigger that calls the stored procedure to update on that particular date. But can you provide me a better option.