???л???????Key-Range?????????????Χ
???????????? ???????[ 2013/2/5 14:39:03 ] ????????
????????????????л??????????????????Χ??????????Χ?????????????????????λ??????л?????????????Χ??????У?????????????????????????????Χ????????
??????????????????????Χ??????????????????????????????
????????????????????
---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???Χ?????????????????????????????
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11