Trigger to update last modified date

In this case, the trigger gets fired before the update queries are executed. It is most commonly used to track and log time of modifications in the database. Here we discuss the introduction, syntax, parameters, examples with code implementation respectively. You may also have a look at the following articles to learn more —. Submit Next Question. By signing up, you agree to our Terms of Use and Privacy Policy. Forgot Password? This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy.

Did you mean:. All posts Previous Topic Next Topic. Ashok2 Post Patron. Update last modified to Today using Flow. Message 1 of 6. Accepted Solutions. Anonymous Not applicable. In response to Ashok2. Message 6 of 6. Message 2 of 6. In response to Anonymous. Message 3 of 6. Message 4 of 6. Message 5 of 6. Post Reply. Helpful resources. Launching new user group features Learn how to create your own user groups today!

In this case, both the CreatedDate and ModifiedDate columns contain the same value. As expected, the ModifiedDate column is updated but the CreateDate column remains the same. Below is a more detailed explanation of the code used to create the table and its associated trigger. I created it on the dbo. The inserted table is a temporary, memory-resident table that SQL Server creates and maintains.