您要查找的是不是：
- ordered sharing lock 有序相容性封锁
- 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设置共享锁,使其与当前事务相关联。
- In order not to be late, she cut across the fields. 为了不迟到，她抄近路穿过田野。
- We started early in order to arrive before dark. 为了在天黑前到达，我们很早就动身了。
- Row versioning removes the need for requesting share locks on rows that have been read. 行版本控制不需要对已读取的行请求共享锁。
- 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. 这样的异常可能导致不良的影响,例如将堆栈跟踪转储到用户界面上,或者没有释放诸如共享锁之类的争用性资源。
- He ordered the troops to limber up and move out. 他命令部队把炮装上前车开出去。
- Binding sessions allows two or more sessions to participate in the same transaction and share locks until a ROLLBACK TRANSACTION or COMMIT TRANSACTION is issued. 绑定会话允许两个或更多的会话参与同一事务并共享锁,直到发出ROLLBACK TRANSACTION或COMMIT TRANSACTION命令。
- The courts ordered the seizure of all her property. 法院下令查封她所有的财产。
- The captain ordered two flags to be placed fore and aft. 船长吩咐在船头和船尾各挂一面旗子。
- The soldiers were ordered to present arms. 士兵们奉命举枪致敬。
- The petition was ordered to lie on the table. 该请愿书奉命暂搁一边，以后讨论。
- She ordered a hamburger and French fries. 她叫了一客汉堡包和炸薯条。
- The sentry was ordered to shoot on sight. 哨兵奉命一发现目标就射击。
