Queries that use NOLOCK aren't guaranteed to return correct results or technically, return any results at all.
使用了NOLOCK的查询并不保证能返回正确地结果,而且从技术上讲,它可能会返回任意结果。
There are also arguments about using NOLOCK at all and where the NOLOCK should live when considering deployment.
也有一些争论是关于NOLOCK选项本身,以及是否应该在部署时使用NOLOCK选项。
However, with NOLOCK (even though "everyone" has used it at some point or another) is generally considered a last resort.
然而,使用NOLOCK(即使“每个人”多多少少都用过这个方法)通常是最后一个可以依靠的手段。
应用推荐