Does anyone know what the net effect of having a block of t-sql with a transaction isolation level of repeatble read and then inside having a select with nolock.
Does the nolock become invalid because the isolation level has already been set?
nolocksql server
Does anyone know what the net effect of having a block of t-sql with a transaction isolation level of repeatble read and then inside having a select with nolock.
Does the nolock become invalid because the isolation level has already been set?
Best Answer
The table hint in the query takes precedence, as I would have expected.
Here's my test script:
With the
NOLOCK
hint included, no locks are taken by theSELECT
statement.In other words, setting the isolation level on the transaction makes that isolation level the default within the transaction, but that default can still be overridden by table hints, as I demonstrated.