can anybody plz explain about timestamp in sqlserver
Printable View
can anybody plz explain about timestamp in sqlserver
Please find the details [URL="http://msdn2.microsoft.com/en-us/library/aa260631(SQL.80).aspx"]here[/URL] and [URL="http://msdn2.microsoft.com/en-us/library/ms182776.aspx"]here[/URL].
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
[QUOTE=vikasvaidya;25710]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[/QUOTE]
Thanks allot Vaidya