这更多的是对我想法的确认,而不是一个问题。可以在 SQL Server 中以表为基础更改隔离级别,还是只能在会话级别上定义/更改,如下面的语句所示?
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
那么 Microsoft SQL Server 中没有类似的东西吗?
ALTER DATABASE SET DEFAULT TRANSACTION ISOLATION LEVEL SERIALIZABLE
或者类似的东西?
CREATE TABLE T(A INT) TRANSACTION ISOLATION LEVEL SERIALIZABLE
我读过的相关问题和答案:
- https://dba.stackexchange.com/questions/221548/is-it-possible-to-set-default-transaction-isolation-for-all-connections-in-sql-s https://dba.stackexchange.com/questions/221548/is-it-possible-to-set-default-transaction-isolation-for-all-connections-in-sql-s
- 如何更改隔离级别? https://stackoverflow.com/questions/14536805/how-to-change-isolation-level
-
https://learn.microsoft.com/en-us/sql/t-sql/statements/set-transaction-isolation-level-transact-sql?view=sql-server-ver15#:~:text=The%20transaction %20隔离%20级别%20定义,%20引用%20由%20%20读取 https://learn.microsoft.com/en-us/sql/t-sql/statements/set-transaction-isolation-level-transact-sql?view=sql-server-ver15#:%7E:text=The%20transaction%20isolation%20levels%20define,are%20referenced%20by%20the%20read.
您可以更改连接的隔离级别,但不能更改连接的隔离级别table
。但是,您可以在某些联接上设置锁定行为,但这可以改善执行某些查询时的锁定争用。
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)