December 1, 2010 at 1:02 am
Hi All....
Anybody can tell me how to use the TIMESTAMP datatype.
CASE:-
in my table i am haivng 100 records. first 10 records i am updating.. next 10 records another person is updating next 10 records updating by another person. all are different differnt locations working on the same database. how can the first user knows these records are updated or tobe update. I told them by using the TIMESTAMP we can know these records are updated. But i don't know how to do that... anybody plz give the solution for this.......
Thanks in Advance to ALL...........
December 1, 2010 at 3:18 am
This article has more information and example on how to use TIMESTAMP datatype.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
December 1, 2010 at 5:44 am
The thing to remember is, despite it's unfortunate name, TIMESTAMP has nothing whatsoever to do with time. It's simply an incrementing number that is automatically updated each time a row gets created or updated. You don't refer to it in your update or insert statements. It manages itself.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply