USE pubs
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO
BEGIN TRANSACTION
SELECT au_lname FROM authors WITH (HoldLOCK)
GO
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO
BEGIN TRANSACTION
SELECT au_lname FROM authors WITH (HoldLOCK)
GO
不过能锁定如SELECT au_lname FROM authors where city='1' 查询的行不能读吗
如不是整张表
不行,怎么办
SELECT au_lname FROM authors WITH(PAGLOCK,XLOCK) where au_lname='Bennet' Waitfor Delay '00:00:04'