I am trying to implement a simple row lock in SQL without the overhead of transactions or even the ‘hassle’ of version numbers
My tentative solution is the following: