SqlServer 控制 SQL 的锁粒度 -- 不加锁 SELECT * FROM tab_a with(NOLOCK) WHERE id = 123 AND column IN ('a','b') -- 使用行锁 UPDATE tab_a WITH(ROWLOCK) SET a = 'a', b = 'b', c = 'c' WHERE id = 1