您要查找的是不是：
- Therefore, other transactions can obtain simultaneous row share, row exclusive, share, and share row exclusive table locks for the same table. 也就是说，其他事务同时也能获得相同表上的行共享，行排他，共享，及共享行排他模式的表级锁。
- Share row exclusive table lock 共享行排他表级锁
- Therefore, row exclusive table locks allow multiple transactions to obtain simultaneous row exclusive and row share table locks for the same table. 即行排他表级锁允许其他多个事务同时获得相同表上的行共享表级锁或行排他表级锁。
- Lock Table TableName In Share Row Exclusive Mode; 它比共享锁有更多限制。定义共享行级排它锁的语法为
- LOCK TABLE IN SHARE ROW EXCLUSIVE MODE 表共享行独占:通过
- If the clustered index is being rebuilt, an exclusive table lock is held. 如果重新生成了聚集索引,则持有排他表锁。
- LOCK TABLE TableName IN SHARE MODE; LOCK TABLE TableName IN SHARE ROW EXCLUSIVE MODE; LOCK TABLE TableName IN ROW EXCLUSIVE MODE; LOCK TABLE TableName IN EXCLUSIVE MODE; 来准确在锁定行而不能更新行。禁止的操作:拥有行级排它锁的事务不允许其它事务有除共享锁外的其它形式的锁加在同一张表上或更新该表。即下面的语句是不被允许的
- Permitted Operations: Only one transaction can obtain an exclusive table lock for a table. An exclusive table lock permits other transactions only to query the table. 允许的操作:同一时间只有一个事务能获得表上的排他表级锁。一个事务获得排他表级锁后,其他事务只能对表进行查询操作。
- Prohibited Operations: An exclusive table lock held by a transaction prohibits other transactions from performing any type of DML statement or placing any type of lock on the table. 禁止的操作:一个事务获得排他表级锁后,将禁止其他事务对表执行任何DML操作,其他事务也无法获取表上任何类型的锁。
- A row share table lock is the least restrictive mode of table lock, offering the highest degree of concurrency for a table. 行共享模式的表级锁的限制程度最低,因而能够保证表的最大的并发访问能力。
- 204 Prohibited Operations: An exclusive table lock held by a transaction prohibits other transactions from performing any type of DML statement or placing any type of lock on the table. 禁止的操作：一个事务获得排他表级锁后，将禁止其他事务对表执行任何DML操作，其他事务也无法获取表上任何类型的锁。
- The Database Engine chooses the appropriate lock and can escalate the lock from a row or page lock to a table lock. 数据库引擎将选择相应的锁,并且可以将锁从行锁或页锁升级到表锁。
- This way all updates and inserts can be performed, except those that require an exclusive (X) table lock. 通过这种方式,除了需要排他(X)表锁的更新和插入以外,可执行所有更新和插入。
- CREATE TRIGGER puts a table lock on the table, and thus requires exclusive use of the table. CREATE TRIGGER将对表进行表锁定,因此需要对表进行排它使用。
- The row containing the cell is a shared row. 包含该单元格的行是共享行。
- Long-term table locks are not held. 不保留长期表锁。
- The rowIndex value lets you specify the actual row index of a shared row. rowIndex值可用来指定共享行的实际行索引。
- The Database Engine does not escalate row or key-range locks to page locks, but escalates them directly to table locks. 数据库引擎不会将行锁或键范围锁升级到页锁,而是将它们直接升级到表锁。
- The SQL Server 2005 Database Engine will not escalate row or page locks to table locks. SQL Server 2005数据库引擎不会将行锁或页锁升级到表锁。
- Read operations acquire no page or row locks; only SCH-S table locks are acquired. 读取操作不获取页锁或行锁,只获取SCH-S表锁。
