How serializable works when multiple conditions exists in where clause?

Hi

SERIALIZABLE takes range locks are placed in the range of key values that match the search conditions of each statement executed in a transaction. This blocks other transactions from updating or inserting any rows that would qualify for any of the statements executed by the current transaction. This means that if any of the statements in a transaction are executed a second time, they will read the same set of rows. The range locks are held until the transaction completes. This is the most restrictive of the isolation levels because it locks entire ranges of keys and holds the locks until the transaction completes. Because concurrency is lower, use this option only when necessary. This option has the same effect as setting HOLDLOCK on all tables in all SELECT statements in a transaction.

Refer http://ift.tt/1A6IFGz

There could be changes your select statement lock either released or not locked at all due to no records present,

we cant tell you much there, unless you provide more inforamtion,

you can also check the locks in sys.dm_tran_locks

Thanks

Saravana Kumar C