Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
samir.first
Starting Member
34 Posts |
 Posted - 2014-01-01 : 02:50:25
|
| how to use type (TimeStamp) in Concurrency |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2014-01-01 : 11:00:59
|
| Usually this is done at front end application language by fetching the current timestamp value along with required data. Then at the time of modification of any attributes within fetched data it will first check for current value of timestamp against the value it saved with data. If there are same, it will go ahead with the modification as the copy is current. If the value has changed in table, it means some modfications have happened since then and copy we've is an obsolete one.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
|
|
|
TimeStamp and concurrency