.

April 15, 2009

UNIQUEIDENTIFIER vs.TIMESTAMP

In SQL Server, UNIQUEIDENTIFIER and TIMESTAMP are data type.

* * Size : Size of TIMESTAMP is 8 bytes - Size of UNIQUEIDENTIFIER is 16 bytes
* Value : TIMESTAMP is not based on system date or time - UNIQUEIDENTIFIER value is based on the computer's MAC addresses and system date time.
* Purpose :
TIMESTAMP - To track the operation in tables on the database level
UNIQUEIDENTIFIER -To unique value assigned to a row (maybe as primary key).
It remains unique in any system in the world

No comments: