| 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 |
|