阅读背景:

SQL Server查询 - 为什么我会遇到死锁?

来源:互联网 

I have the following code:

我有以下代码:

set transaction isolation level read committed; --this is for clarity only

DECLARE @jobName nvarchar(128);

BEGIN TRAN
    SELECT @jobName = JobName
    FROM dbo.JobDetails
    WHERE ExecutionState_Status = 1

    WAITFOR DELAY '00:00:10'

    UPDATE dbo.JobDetails
    SET ExecutionState_Status = 10
    WHERE JobName = @jobName

COMMIT 
set tran



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

分享到: