随笔分类 -  SQL Server

SQLServer Transaction Isolation Level
摘要：基本用法 -- Syntax for SQL Server and Azure SQL Database SET TRANSACTION ISOLATION LEVEL { READ UNCOMMITTED | READ COMMITTED | REPEATABLE READ | SNAPSHOT 阅读全文
posted @ 2017-08-02 13:43 StevenGuan 阅读(747) 评论(0) 推荐(0)
SQL Server事务相关
摘要：SELECT SESSION_ID,DEADLOCK_PRIORITY,TRANSACTION_ISOLATION_LEVEL FROM SYS.DM_EXEC_SESSIONS DEADLOCK_PRIORITY： LOW Specifies that the current session wi 阅读全文
posted @ 2016-10-11 15:01 StevenGuan 阅读(3) 评论(0) 推荐(0)