如何配置MS SQL服务器以避免更新锁(LCK_M_U)

I have MS SQL server with a database containing several tables. Each table has a field 'SN'. Several clients can work with this database, but every client operates only with records with its own value of SN.I have MS SQL server with a database containing