Thread: time stamp

can anybody plz explain about timestamp in sqlserver

Please find the details here and here.

The SQL Server timestamp data type has nothing to do with times or dates. SQL Server timestamps are binary numbers that indicate the relative sequence in which data modifications took place in a database. The timestamp data type was originally implemented to support the SQL Server recovery algorithms.


----V V----
Regards,
Vikas Vaidya

Originally Posted by vikasvaidya

The SQL Server timestamp data type has nothing to do with times or dates. SQL Server timestamps are binary numbers that indicate the relative sequence in which data modifications took place in a database. The timestamp data type was originally implemented to support the SQL Server recovery algorithms.


----V V----
Regards,
Vikas Vaidya

Thanks allot Vaidya