22,209
社区成员
发帖
与我相关
我的任务
分享
declare @tmpId bigint
BEGIN TRANSACTION
SELECT top 1 @tmpId=Id FROM data rowlock WITH (tablockx) WHERE dstatus=0
update data set dstatus=1 where Id=@tmpId
select * from data where Id=@tmpId
COMMIT TRANSACTION