What do I gain by adding a timestamp column called recordversion to a table in ms-sql?

What do I gain by adding a timestamp column called recordversion to a table in ms-sql?

Answers


You can use that column to make sure your users don't overwrite data from another user.

Lets say user A pulls up record 1 and at the same time user B pulls up record 1. User A edits the record and saves it. 5 minutes later, User B edits the record - but doesn't know about user A's changes. When he saves his changes, you use the recordversion column in your update where clause which will prevent User B from overwriting what User A did. You could detect this invalid condition and throw some kind of data out of date error.


Need Your Help

JavaScript Increment ++ Opacity On each Click

javascript jquery onclick opacity increment

Hi i am having trouble incrementing the opacity of a background-color:hsla() div using JavaScript. This is the code i am using...

QtcpSocket without signals/slots

qt qt4 qtcpsocket

Is it possible to use QTcpSocket without using readyRead slots ?

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.