...供了4种隔离等级: READ UNCOMMITTED(读未提交的数据) READ COMMITTED(读提交的数据) READ REPEATABLE(可重复读) SERIALIZABLE(可串行化) SQL Server中的隔离等级可以通过如下形式设置: SET TRANSACTION ISOLATION LEVEL READ COMMITTED...
基于16个网页-相关网页
Repeatable Read 可重复读 ; 可重复读取 ; 重复读 ; 可重读
Non-repeatable Read 不可重复读 ; 不可重复的读 ; 非重复读 ; 重复读
RR-Repeatable Read 可重复读
Repeatable read isolation 可重复读级别
non-repeatable read problem 不可重复读问题
REPEATABLE-READ 可重复读
locking REPEATABLE READ 锁可重复读
read-uncommited read-commited repeatable-read serializable 提交前读
In fact, the only row-level locking that remains during INSERT is the next-key locks that are required to protect an INSERT from adding keys to repeatable read scanners.
实际上,在INSERT期间惟一保持的行级锁是next - key锁,这个锁用于使INSERT不会添加键到可重复的读扫描器。
Supports table and row level locking and 4 isolation levels, RR (repeatable read), rs (read stability), CS (default - cursor stability) and ur (uncommitted read).
支持表级和行级锁以及4个隔离级别:RR(可重复读)、RS(读可靠)、CS(默认——游标可靠)和UR(未提交读)。
With the "Repeatable Read" data region fetch requests issued multiple times within the same transaction will always produce the same result yielding better application throughput.
在相同事务下对“可重复读取”区域内数据的多次请求的结果是相同的,但能够带来更好的应用吞吐量。
应用推荐