Timestamp

Question

Timestamp

VastSQL

SSC-Dedicated

Points: 36121
More actions
July 14, 2008 at 7:52 am

#122373

Hi experts,
What are the advantage of using timestamp datatype???
TIA

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Michael Earl-395764 SSC Guru Points: 53873 More actions · Answer 1

It is generally used for dealing with concurrency. It is not a date, but it is automatically changed each time a record is updated. So, a method of verifying a record has not changed since you read the data is to check if the timestamp field has been modified.

VastSQL SSC-Dedicated Points: 36121 More actions · Answer 2

Thanks Earl,

I like to know how to check whether a column is modified and when???

GSquared SSC Guru Points: 260824 More actions · Answer 3

Check out these articles and their discussions. All kinds of data on how to keep track of what's been changed, when, and by whom:

http://www.sqlservercentral.com/articles/Auditing/63247/

http://www.sqlservercentral.com/articles/Auditing/63248/

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon