You need to read about locking in SQL Server to understand the consequences of what you are asking for. When you get to understanding you stop to ask for trouble.

You may try to work-around by flagging a record you have opened for editing.

But then you need to figure out how to release blocked record when connection is dropped or when user went home leaving the record blocked, or... Try figure.