DBA > Job Interview Questions > Microsoft SQL Server FAQs

What is the granularity in seconds of the timest

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is the granularity in seconds of the timestamp datatype?

Answer
The timestamp datatype does not store time values.

Explanation
The answer is the timestamp datatype does not store time values. The better name for this datatype is rowversion, and it is actually a database-wide unique varbinary value. When you have a rowversion column in a table, the value of the rowversion column changes for each modification to each row. The value in the rowversion column is guaranteed to be unique across all tables in the datatype.

(Continued on next question...)

Other Job Interview Questions