本文介绍了如何在SQL Server中查询当前的事务隔离级别，并提供了设置特定隔离级别的示例，包括使用读已提交快照的功能。
--读取SQL Server的当前transaction isolatin level
SELECT CASE transaction_isolation_level
WHEN 0 THEN 'Unspecified'
WHEN 1 THEN 'ReadUncommitted'
WHEN 2 THEN 'ReadCommitted'
WHEN 3 THEN 'Repeatable'
WHEN 4 THEN 'Serializable'
WHEN 5 THEN 'Snapshot' END AS TRANSACTION_ISOLATION_LEVEL
FROM sys.dm_exec_sessions
where session_id = @@SPID
--设置ISOLATION LEVEL
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
--设置启用读写隔离
ALTER DATABASE HINAMIIS_Domain
SET READ_COMMITTED_SNAPSHOT ON
SELECT CASE transaction_isolation_level
WHEN 0 THEN 'Unspecified'
WHEN 1 THEN 'ReadUncommitted'
WHEN 2 THEN 'ReadCommitted'
WHEN 3 THEN 'Repeatable'
WHEN 4 THEN 'Serializable'
WHEN 5 THEN 'Snapshot' END AS TRANSACTION_ISOLATION_LEVEL
FROM sys.dm_exec_sessions
where session_id = @@SPID
--设置ISOLATION LEVEL
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
--设置启用读写隔离
ALTER DATABASE HINAMIIS_Domain
SET READ_COMMITTED_SNAPSHOT ON
扫一扫
1265
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
