The documentation makes it clear that you can use the READCOMMITTEDLOCK table hint to get the default SET TRANSACTION ISOLATION LEVEL READ COMMITTED behaviour when the non-default READ_COMMITTED_SNAPSHOT option is enabled. Is there a transaction isolation level equivalent to this? That is, when the READ_COMMITTED_SNAPSHOT option is enabled, is there a transaction isolation level that would let me act if it is disabled and I'm running under a READ COMMITTED isolation level?
1条答案
按热度按时间uz75evzq1#
when the READ_COMMITTED_SNAPSHOT option is enabled, is there a transaction isolation level that would let me act if it is disabled and I'm running under a READ COMMITTED isolation level?
No. But REPEATABLE READ and SERIALIZABLE will force reading with S locks.