Month: July 2018
Find version of SQLSERVER
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
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 »