SQL: Implementing Optimistic Concurrency in SQL Server with RowVersion

added by DotNetKicks
10/2/2018 1:42:25 PM

1 Kicks, 1305 Views

It's common to need to have a way to read a row of data from a table, to be able to modify it, and to then update it back into the table, but only if it hasn't been changed in the meantime. But we don't want to lock it in the meantime.