select for update

select for update enables Adaptive Server to exclusively lock rows for subsequent updates within the same transaction, and for updatable cursors, preventing other concurrent tasks from updating these rows and from blocking the subsequent update

See “Queries: Selecting Data from a Table” in the Transact-SQL Users Guide.