Subject How to detect a record changed between read and update?
Author Constantijn Wolfs cw.s
Hello,

I want to raise an exception when a record changed between the original
read and the update with a sp.

I could do a select on the old values and proceed with the update when
the record was found. But is there a better way to do this, making the
change of overwriting other updates as small as possible, without locking?

Constantijn