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
April 15, 2009
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment