USE pubs GO SET TRANSACTION ISOLATION LEVEL SERIALIZABLE GO BEGIN TRANSACTION 'XLOCK - 排他锁,ROWLOCK - 行级锁,READPAST - 跳过其它数据锁定的行 SELECT TOP 1 * FROM xxx WITH (XLOCK, ROWLOCK, READPAST) GO
USE pubs GO SET TRANSACTION ISOLATION LEVEL SERIALIZABLE GO BEGIN TRANSACTION --XLOCK - 排他锁,ROWLOCK - 行级锁,READPAST - 跳过其它数据锁定的行 SELECT TOP 1 * FROM xxx WITH (XLOCK, ROWLOCK, READPAST) GO
USE pubs
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO
BEGIN TRANSACTION
'XLOCK - 排他锁,ROWLOCK - 行级锁,READPAST - 跳过其它数据锁定的行
SELECT TOP 1 * FROM xxx WITH (XLOCK, ROWLOCK, READPAST)
GO
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO
BEGIN TRANSACTION
--XLOCK - 排他锁,ROWLOCK - 行级锁,READPAST - 跳过其它数据锁定的行
SELECT TOP 1 * FROM xxx WITH (XLOCK, ROWLOCK, READPAST)
GO