27,582
社区成员




BEGIN TRAN
SELECT *
FROM 表 WITH ( ROWLOCK, UPDLOCK )--加更新锁,并保持到事务结束
WHERE id = 1
UPDATE 表
SET 字段 = '123'
WHERE id = 1
COMMIT TRAN
BEGIN TRAN
SELECT *
FROM 表 WITH ( ROWLOCK, UPDLOCK )--加更新锁,并保持到事务结束
WHERE id = 1
UPDATE 表
SET 字段 = '123'
COMMIT TRAN
[/quote]
更新全表?BEGIN TRAN
SELECT *
FROM 表 WITH ( ROWLOCK, UPDLOCK )--加更新锁,并保持到事务结束
WHERE id = 1
UPDATE 表
SET 字段 = '123'
COMMIT TRAN
BEGIN TRAN
SELECT *
FROM 表 WITH ( UPDLOCK, HOLDLOCK )--加更新锁,并保持到事务结束
UPDATE 表 SET 字段 = '123'
COMMIT TRAN