SQLUSA

Microsoft SQL Server 2000

Best Practices

 

How to use the timestamp data type?

 

The timestamp datatype provides a unique row versioning within a database. It is typically used in multi-user environment by software developers. When displaying the information to the user for change, the timestamp value is noted. The user is allowed to change values on the update screen. Upon submit, the program checks if the timestamp value the same. If not, somebody changed the data in between, the appropriate action is taken. If they are the same, the update is performed.

 

Best in the World in SQL Server Training
 
SQLUSA.com Home Page