SQL Server JDBC - Re: time stamp magicaly updated when ever update event occures on

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

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

Joe Weinstein

2005-12-08, 8:23 pm

Daniel wrote:

> 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?
>
>

Hi. Read the SQLServer documents about the timestamp column. It is designed
precisely to do what you see. It has no value to you until you read that
documentation, and it does not represent any human-interpretable time or date.

Joe Weinstein at BEA Systems

Sponsored Links