Serializable Repeatable read Read committed Read uncommitted Serializable This level prohibits the following types of reads: – Dirty reads: A transaction reads a database row containing uncomm
这两种隔离级别都是通过行版本控制在tempdb中生成数据的复本来解决数据的写和读的时候发生锁及阻塞的问题的。不过snapshot isolation需要在数据库中执行 ALTER DATABASE Aesop SET ALLOW_SNAPSHOT_ISOLATION ON 之后,然后在执行事务之前,设置连接的隔离级别 SET TRANSACTION ISOLATION LEVEL Snapsho