A blog for Microsoft Technologeis, Articles, Reviews,Best Practices, Upcoming Microsoft Technologies particulary related to Windows Server System and .NET 2.0 and related Discussions. The purpose of this blog is to provide a resource to the quick information that Application Developers,Designer and Architects need on Microsoft's Technologies for developing and integrating these technologies.
"T H E K N O W L E D G E W H I C H I S C O N C E A L E A D I S L O S T"
Tuesday, May 08, 2012
Timestamp and RowVersion Usage and Behaviour in SQL SERVER
I have gone through a different experience today. On of my coleague ask me to get latest users data from a table. when i looked into table structure it does not have any date or time datatype. When i raise the question that if he wants me to return data on the basis of Id he replies no i have defined a timestamp column use that by using date time conversion. When i tried there is an error message that database engine is unable to convert timestamp into date time. On most of the times people think that timestamp is some type of date and time data type and can return date.
In this blog we will look into timestamp datatype, its usage and what is the difference between timestamp and rowversion. From microsoft fourms i have got following details.