您要查找的是不是：
- However, other transactions cannot acquire an exclusive lock until the shared lock has been released. 但是,在释放共享锁之前,其他事务无法获取排他锁。
- This means that the shared lock is held until the client requests the rest of the data. 这意味着共享锁将继续保持,直到客户端请求了其余的数据为止。
- Specifies that a shared lock is taken on the table held until the end-of-statement. 指定表采用的共享锁一直保持到语句结束。
- Using the TABLOCK hint causes the delete operation to take a shared lock on the table instead of a row or page lock. 使用TABLOCK提示会导致删除操作获取表的共享锁,而不是行锁或页锁。
- If a nonclustered index is being rebuilt, a shared lock is held on the table in question for the duration of the operation. 如果重新生成了非聚集索引,则在该操作的持续时间内,相关表持有共享锁。
- If all rows from the first page fit on the TDS packet, SQL Server releases the shared lock on that page but leaves a shared lock on the second page. 如果第一页中的所有行都能放入TDS包中,SQL Server将释放此页上的共享锁,但在第二页上仍保留一个共享锁。
- The following example places a shared lock, which is associated with the current transaction, on the resource Form1 in the AdventureWorks database. 以下示例对AdventureWorks数据库中的资源Form1设置共享锁,使其与当前事务相关联。
- Such exceptions can cause the undesirable effects of for example dumping the stack trace on the user interface or not releasing a contentious resource such as a shared lock. 这样的异常可能导致不良的影响,例如将堆栈跟踪转储到用户界面上,或者没有释放诸如共享锁之类的争用性资源。
- Other users can read the data concurrently, but no transaction can acquire an exclusive lock on the data until all the shared locks have been released. 其他用户可以同时读取数据,但在释放所有共享锁之前,任何事务都不能获取对该数据的排他锁。
- IX is a superset of IS, and it also protects requesting shared locks on lower level resources. IX是IS的超集,它也保护针对低层级别资源请求的共享锁。
- A dirty read is possible, meaning that no shared locks are issued and no exclusive locks are honored. 可以进行脏读,意思是说,不发布共享锁,也不接受独占锁。
- Data modification statements, therefore, typically request both shared locks and exclusive locks. 因此,数据修改语句通常请求共享锁和排他锁。
- Snapshot replication places shared locks on all tables published as part of replication for the duration of snapshot generation. 在快照生成期间,快照复制会在作为复制的一部分发布的所有表上放置共享锁。
- He chiseled a hole in the door to fit a new lock. 他在门上凿了个孔，以便装一把新锁。
- This includes both the shared locks from the SELECT statement and the exclusive locks from the previous UPDATE statement. 这包括来自SELECT语句的共享锁和来自上一个UPDATE语句的排他锁。
- This lock can only be opened from the inside. 这把锁只能从里面打开。
- He put the key in the lock and turned it. 他把钥匙插入锁里转动。
- This means that shared locks are placed on the two pages that contain the rows that you must have to satisfy your query. 这意味着共享锁放置在这两个包含必须用来满足查询的行的页上。
- We must put a new lock on the front door. 我们得在前门上安一把新锁。
- Someone has been tampering with the lock. 有人乱动过这把锁。
