Hello,

In DB2, we can do FOR UPDATE selection, in order to lock the records until the transaction is completed. e.g.

select field1, field2, field3
from table
FOR UPDATE;

How can I perform the equivalent feature in SQL Server?

Thanks!