行锁

• 0 index does not allow row locks
  0 =索引不允许行锁。
• It attempts to escalate all locks held by the current transaction on
  中获取至少5 , 000个行锁时，会尝试升级当前事务在
• Row and page locks options
  行锁和页锁选项
• Specifies that row locks are taken when page or table locks are ordinarily taken
  指定通常采用页锁或表锁时，采用行锁。
• That are held until the transaction completes . performs a select that joins
  中生成排他行锁，直到事务完成后才会释放该锁。
• Understanding row locking
  >了解行锁定
• Row locks are not used
  未使用行锁。
• Read operations acquire no page or row locks ; only sch - s table locks are acquired
  读取操作不获取页锁或行锁，只获取sch - s表锁。
• Read operations require only sch - s table level locks and no page or row locks
  读取操作只需要sch - s表级别的锁，不需要页锁或行锁。
• The sql server 2005 database engine will not escalate row or page locks to table locks
  Sql server 2005数据库引擎不会将行锁或页锁升级到表锁。