Re: time stamp magicaly updated when ever update event occures on a row
- From: "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@xxxxxxxxxx>
- Date: Fri, 9 Dec 2005 08:02:56 +0100
This is regular behavior. Timestamp is used as a mechanism for
version-stamping table rows. It is a 8-byte binary string, which has nothing
to do with time (is not the same as the timestamp data type defined in the
SQL-92 standard) - it is more like sequential number unique within a
database. Timestamp columns are updated automatically by SQL Server on every
Insert or Update of a row.
--
Dejan Sarka, SQL Server MVP
Mentor
www.SolidQualityLearning.com
"Daniel" <softwareengineer98037@xxxxxxxxx> wrote in message
news:eAZg5yE$FHA.3452@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?
>
>
.
- Prev by Date: Query success in Query Analyzer but not in Reporting Services?
- Next by Date: problem with new sql server 2005 install
- Previous by thread: Query success in Query Analyzer but not in Reporting Services?
- Next by thread: problem with new sql server 2005 install
- Index(es):
Relevant Pages
|
