在更新时绕过锁定的记录 [英] Bypass locked records on update

问题描述

我正在使用以下更新命令来更新已被另一笔交易锁定的表

I''m using following update command to update table that has locked by another transaction

UPDATE tableName with (readpast)

但这在sql server2008上有效，而在sql server2000上无效.在sql server2000中更新锁定表时，是否还有其他关键字可以使用.

But this works on sql server2008 and not working on the sql server2000. Is there any other key word to use when updating a locked table in sql server2000.

推荐答案

在MS SQL Server 2000中READPAST，NOLOCK和不允许.

有关更多信息，请访问:更新(SQL Server 2000) [ ^ ]

尝试使用授予权限来仔细考虑可能的任务方法 [ ^ ]或使用所有权链 [权限 [ GRANT [

In MS SQL Server 2000 READPAST, NOLOCK, and READUNCOMMITTED are not allowed.

More at: UPDATE (SQL Server 2000)[^]

Try to mull over possible approaches to the task with Granting permissions[^] or Using Ownership chains[^].
PERMISSIONS[^]
GRANT[^]

这篇关于在更新时绕过锁定的记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！