阅读背景:

在查询中使用NOLOCK表提示使用View -它会在视图中传播吗?

来源:互联网 

If a "WITH NOLOCK" query hint is used on a View in SQL Server, does it propagate that hint to the view definition itself, even if NOLOCK is NOT used for the raw tables in the View definition? The reason to need this is that sometimes the support staff wants to do huge time-consuming queries but would rather not force this lock on all queries using the view within the application itself.If a "WITH NOLOCK" query hint is used on a View




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: