Daniel Roth <[EMAIL PROTECTED]> writes:
> It sates: "To guarantee true mathematical serializability, it is
> necessary for a database system to enforce predicate locking, which
> means that a transaction cannot insert or modify a row that would have
> matched the WHERE condition of a query in anoth
Hi Tom
Apologies for my previous double post.
In "12.2.2.1. Serializable Isolation versus True Serializability"
It sates: "To guarantee true mathematical serializability, it is
necessary for a database system to enforce predicate locking, which
means that a transaction cannot insert or modify a
Daniel Roth <[EMAIL PROTECTED]> writes:
> But MSSQL (SQL Server) does predicate locking.
> Places a range lock on the data set, preventing other users from
> updating or inserting rows into the data set until the transaction is
> complete. This is the most restrictive of the four isolation levels.
