Select from following answers:- ROWLOCK
- READPAST
- TABLOCK
- All Above
When you use the ROWLOCK table query hint, row locks will be used when page or table locks are likely to be used.
When you use the READPAST table query hint, rows in the table locked by other transactions are skipped rather than blocking the transaction.
Show Correct Answer
Source: Microsoft press book | |
Alert Moderator