use lock hints within a transaction ( it is not simple to implement and control )
* examplesBEGINTRAN
... WITH (UPDLOCK,ROWLOCK) ....
* NOW YOU HAVE EXCLUSIVE WRITE ACCESS TO SELECTED ROWS UNTIL ROLLBACK OR COMMIT* attention, SQL can excalade lock to pages or table