Month: July 2018

Find version of SQLSERVER

Posted on

We often want to know about the version we are using. There are few simple ways to get the version you are on.

1. Simplest way: Read the rest of this entry »

Difference Between ROWVERSION and TimeStamp – SQLSERVER

Posted on

No difference! rowversion is new name for timestamp or we can say a synonym for timestamp datatype.  Actually, the “Timestamp” datatype was defined as a counter of database row updates. Later, the ISO defined the “Timestamp” datatype as date and time information, causing a conflict between the SQL standards definition and the specific usage by MS SQL-Server. So Microsoft replaced the name “timestamp” by a new name “rowversion” Read the rest of this entry »