Which locking hint should you use?

You have a stored procedure that is used to set up maintenance tasks. The stored
procedure executes every night. The stored procedure contains three critical data
manipulation language (DML) statements that operate against a single table. You need to
prevent users from modifying any data in the table while the stored procedure executes.
Which locking hint should you use?

You have a stored procedure that is used to set up maintenance tasks. The stored
procedure executes every night. The stored procedure contains three critical data
manipulation language (DML) statements that operate against a single table. You need to
prevent users from modifying any data in the table while the stored procedure executes.
Which locking hint should you use?

A.
TABLOCKX

B.
NOLOCK

C.
READCOMMITTED

D.
REPEATABLEREAD



Leave a Reply 0

Your email address will not be published. Required fields are marked *