| Update records in SQL table by using rowlock in MSSQL Server?
Well to stop concurrency you can use a MSSQL concept that is rowlock. Below is the query to do row lock and update records in the table.
BEGIN TRANSACTION;
update temptable with(rowlock) set col1= 'ABC' where id = 2
COMMIT
| | |