SELECT 语句的默认事务锁定行为 SET TRANSACTION ISOLATION LEVELSET TRANSACTION ISOLATION LEVEL
SET TRANSACTION ISOLATION LEVEL控制由连接发出的所有 Microsoft® SQL Server™ SELECT 语句的默认事务锁定行为。语法SET TRANSACTION ISOLATION LEVEL { READ COMMITTED | READ UNCOMMITTED | REPEATABLE READ