The Read committed table hint in SQL Server enforces read committed level with locking behavior when accessing a specific table, regardless of the transaction’s currently isolation level. This ensures that the query does not read uncommitted (Dirty) data and acquire shared locks while reading.
This will ensure that the only
committed data is read. This acquires that the only committed data, which are
released immediately after that read which hold lock locks until the
transaction end. If the database has read committed snapshot enable this hint
forces lock instead.
No comments:
Post a Comment
If you have any doubt, please let me know.