Isolation levels

http://blogs.msdn.com/craigfr/archive/2007/04/25/read-committed-isolation-level.aspx
http://blogs.msdn.com/craigfr/archive/2007/05/02/query-plans-and-read-committed-isolation-level.aspx
http://blogs.msdn.com/craigfr/archive/2007/05/09/repeatable-read-isolation-level.aspx

Is the behaviour described in these posts the *correct* behaviour, as defined by ANSI SQL standards, considering the Read Committed and Repetable Read isolation levels, respectively ? Do other DBMS-s behave the same way ? I am aware that the behaviour would be different if we use snapshot isolation, but I'm interested how things *should* work without snapshot isolation.

I'd like some responses from people who know really well the ANSI SQL standard and the isolation levels defined in it.

Razvan Received on Tue May 15 2007 - 17:15:56 CEST