4种隔离级别理解.docVIP

waitfor delay 00:00:02 延时2 秒 ■ Read uncommitted—Permits dirty reads but not lost updates. One transaction may not write to a row if another uncommitted transaction has already written to it. Any transaction may read any row, however. This isolation level may be implemented using exclusive write locks.未提交读。未授权读取－允许脏读取，但不允许更新丢失。如果一个事务已经开始写数据，则另外一个数据则不允许同时写。但允许其他事务读此行数据。该隔离级别可以通过“排他写锁”实现。例： 事务A开始修改该数据； 事务B不允许同时修改该数据，但允许读取该数据。 事务A: BEGIN TRAN SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED UPDATE tb_User SET password=111111 WHERE account=sys --ROLLBACK --故意不提交或回滚事务B: SET LOCK_TIMEOUT