Sql trigger set date on update

Also it's worth considering getUtcDate depending on your timezone requirements. I didn't get it. Where does the variable Inserted come from? Show 7 more comments. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. 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. This table contains details pertaining to books available in a library.

We can use the following code snippet to create the said table. The query returned successfully. Step 1: Create a trigger in SQL, which automatically updates the date and time of borrowing a book from the collection. We can check the newly created trigger in the object explorer. The following select query can be used to check the same. But it is not always easy to maintain last update date for each row if your application is huge and complex containing many stored procedures which update target database tables.

OrderItems table is our sample database table in this SQL tutorial. Assume that it is important for sql developers or database application users to keep and see the last update date field up-to-date.