“每个语句(select/insert/delete/update)都有一个隔离级别,无论是否在事务中”这是真的吗?
我有一个场景,在其中我设置了在事务中更新语句(ReadCommitted)。还有另一组不在事务中的语句(select语句)。
- In this case when first set is executing another waits.
If I set READ_COMMITTED_SNAPSHOT for DB Deadlock occurs.
ALTER DATABASE Amelio SET ALLOW_SNAPSHOT_ISOLATION ON ALTER DATABASE Amelio SET READ_COMMITTED_SNAPSHOT ON