NOLOCK由于sql server中的数据移动？ [英] NOLOCK due to data movement in sql server?

问题描述

问题是插入数据然后更新索引。如果在更新数据之后但在更新索引之前读取索引，则会导致以下错误：

The problem is that the data is inserted and then the index is updated. If the index is read after the data has been updated but before the index is updated then this can cause the following error:

Number = -2147217900, Description = Could not continue scan with NOLOCK due to data movement., Source = Microsoft OLE DB Provider for SQL Server,

推荐答案

请尝试使用以下链接



http://social.msdn.microsoft.com/Forums/sqlserver/en-US/b31115a4-64d8 -4186-84a9-591faf976066 / can-not-continue-with-nolock-due-to-data-movement [ ^ ]

Please try with below link

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/b31115a4-64d8-4186-84a9-591faf976066/could-not-continue-scan-with-nolock-due-to-data-movement[^]

这篇关于NOLOCK由于sql server中的数据移动？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！