Re: time stamp magicaly updated when ever update event occures on a row


"Daniel" <softwareengineer98037@xxxxxxxxx> wrote in message
news:%23ArsAzE$FHA.356@xxxxxxxxxxxxxxxxxxxxxxx
> time stamp magicaly updated when ever update event occures on a row
>
> in sql server 2000 i have a table. when i do any update on the table, a
> field of the effected rows gets a new time stamp, there are no triggers
> on
> the table, nothing special in the DDL of the table, is there any other way
> besides a table specific trigger that this time stamp could be getting
> updated when i do an update on a row? perhaps some other kind of trigger
> that is not specific to a table but specific to a fielde name in any
> table?

It's part of the definition of column type [deprecated name] timestamp, aka
[new name] rowversion. Its value is updated automatically when a row is
changed. Its value cannot be manually assigned. There can only be one
column of this type per table.

Short answer: it's special like that. :-)


-Mark


.

Relevant Pages