TimeStamp Field

mcarpentieri
mcarpentieri Member Posts: 23
edited 2012-02-22 in SQL General
I have a client that would like to know the answer to the following question:

Does the value in the timestamp field on the G_L Entry table change if there is any change on the record? Is it a standard SQL Server rowversion/timestamp field?

Any help would be greatly appreciated.

Comments

  • kriki
    kriki Member, Moderator Posts: 9,121
    Yes. Yes.

    PS: Don't use if for any processing logic because in a future version of SQL Server it may not exist anymore. It is deprecated.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • pdj
    pdj Member Posts: 643
    Kriki is right, but please read this thread for more information: viewtopic.php?t=51562
    Regards
    Peter

Categories