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



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?


.



Relevant Pages

  • time stamp magicaly updated when ever update event occures on a row
    ... time stamp magicaly updated when ever update event occures on a row ... in sql server 2000 i have a table. ... field of the effected rows gets a new time stamp, ... besides a table specific trigger that this time stamp could be getting ...
    (microsoft.public.sqlserver.datawarehouse)
  • time stamp magicaly updated when ever update event occures on a row
    ... time stamp magicaly updated when ever update event occures on a row ... in sql server 2000 i have a table. ... field of the effected rows gets a new time stamp, ... besides a table specific trigger that this time stamp could be getting ...
    (microsoft.public.sqlserver.xml)
  • time stamp magicaly updated when ever update event occures on a row
    ... time stamp magicaly updated when ever update event occures on a row ... in sql server 2000 i have a table. ... field of the effected rows gets a new time stamp, ... besides a table specific trigger that this time stamp could be getting ...
    (microsoft.public.sqlserver.security)
  • Re: time stamp magicaly updated when ever update event occures on a row
    ... to do with time (is not the same as the timestamp data type defined in the ... Timestamp columns are updated automatically by SQL Server on every ... > field of the effected rows gets a new time stamp, ... > besides a table specific trigger that this time stamp could be getting ...
    (microsoft.public.sqlserver.datamining)
  • Re: time stamp magicaly updated when ever update event occures on a row
    ... whenever theres a data change in the same row. ... The engine handles that part. ... > field of the effected rows gets a new time stamp, ... > besides a table specific trigger that this time stamp could be getting ...
    (microsoft.public.sqlserver.datawarehouse)

Loading