????????????????л??????????????????Χ??????????Χ?????????????????????λ??????л?????????????Χ??????У?????????????????????????????Χ????????

??????????????????????Χ??????????????????????????????

????????????????????

---create tableand insert test data
CREATE TABLE TEST(C1INTprimary key??C2VARCHAR(20))
INSERT INTO testVALUES(1??'TEST')??(2??'TEST')??(3??'EST')
--??????????????

SET TRANSACTIONISOLATIONLEVELSERIALIZABLE
BEGIN TRAN
SELECT * FROM test WHERE C1 BETWEEN 1 AND 3
--??????????????
INSERT INTO testVALUES(100??'TEST')

???????????????Rang??????????1-3?????????????????е?????????κ????????????100??????????????е?? ???????100?????????Block?????С?

???????sys.dm_tran_locks??resource_description?????????????“ffffffffffff”?????????????Χ????1??2??3????????????????????1??2??3????????????????????Rang??Χ?г?????

??????MSDN????? ?????????RangeS-S???????n+1?????n????????????????????????????Χ????????Χ?????Χ+???????NEXT????????????NEXT?????

?????????????????????????????????????????????????????????Next??????????????Key-range???Χ??????????????????????????4?????????????????????г????????????????1-4??100???????????Χ???????????????????

??????????????????????Rang Lock???Χ?????????????????????????????