Understanding TIMESTAMP (ROWVERSION) in SQL Server: ASP Alliance

Print Add To Favorites Email To Friend Rate This Article
Understanding TIMESTAMP (ROWVERSION) in SQL Server

page 7 of 7

by Abhishek Kumar Singh
Feedback

Average Rating:

Views (Total / Last 10 Days): 14557/ 391

Article Contents:

Conclusion

In a more complex scenario, TIMESTAMP features are being used in data-level security requirements, like in building digital signatures. This mechanism helps in verifying that data or document is not modified since at a certain point of time or change. This is used in encryption-decryption techniques, for example RSA algorithm uses timestamp in coding.

« (Page 6)

View Entire Article

Article Feedback

Comment:
Title:
Name:
Url:	( Optional )

Please add 6 and 6 and type the answer here:

User Comments

Title: timestamp problem
Name: arpizt
Date: 10/29/2009 9:35:55 PM
Comment:
"UPDATE table SET field = current_timestamp where (field=1)"
Error msg this field cannot been update.

Thanks.

Title: arpizt@gmail.com
Name: abhishek
Date: 10/28/2009 6:41:21 PM
Comment:
arpizt@gmail.com can you post your query here?

Title: timestamp problem
Name: arpizt@gmail.com
Date: 10/27/2009 5:53:58 AM
Comment:
Hi,

I try to run the insert sql, but got this error ("Column or expression 'PaymentDate' cannot be updated." Why? How to overcome this problem?

Title: Abhishek Your Time Stamp Aarticle too good
Name: Gbbs Mith
Date: 6/13/2009 5:02:18 AM
Comment:
The article is very good because it was justified clearly time and datetime data type. Hope more such article

Thanks

Title: Beginner
Name: nagarajan
Date: 3/17/2009 9:47:06 AM
Comment:
excellent artice about TIMESTAMP.

Title: job
Name: eak
Date: 1/8/2009 2:17:28 AM
Comment:
http://www.sqlhacks.com/index.php/Dates/Timestamp

Title: good
Name: Jen
Date: 12/18/2008 4:57:37 AM
Comment:
good for quick walkthrough.