I see some of the project they always have timestamp/rowversion in the DB tables, but all the while i was trained to use audit fields ( created and modified columns).  Due to curiosity, i google it and this give a a different angle to see this field type and might be useful for my debug life in future.

This post by Abhishek Kumar Singh explains Timestamp very well. He give examples on how the time stamp column behave when insert and update transaction happened. He explains the benefit of TIMESTAMP in multi-user access on table, very interesting article.

tshirt

Advertisements