Post reply

update time

  • November 29, 2005 at 1:22 pm

    #95958

    I am capturing system date when a new row is inserted with getdate() function, how can I update the date when the row is updated.

  • November 29, 2005 at 1:26 pm

    #606533

    use a trigger

     


    * Noel

  • November 30, 2005 at 6:23 am

    #606690

    you can an update trigger as suggested by noel or if you prefer you can use the update statement when you are updating your data to just update the date value.

    Everything you can imagine is real.

  • November 30, 2005 at 9:18 am

    #606790

    Yes, but if you rely on people to remember to update the update column, it won't be updated every time. An update trigger is the best solution.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply