use Test
go
if object_id('XLockShareCluster') is not null
drop table XLockShareCluster
go
;with
L0 as (select 1 as ID union all select 1),
L1 as (select a.ID from L0 as a ,L0 as b),
L2 as (select a.ID from L1 as a ,L1 as b),
L3 as (select a.ID from L2 as a ,L2 as b),
L4 as (select a.ID from L3 as a ,L3 as b),
L5 as (select a.ID from L4 as a ,L4 as b),
SeqID as (select row_number()over(order by ID ) as ID from L5)


select ID,'A' as Name,3 as data into XLockShareCluster from SeqID where ID<=5000

alter table XLockShareCluster 
alter column ID int not null

alter table XLockShareCluster
add constraint PK_XLockShareCluster
primary key clustered
(ID)on [primary]

create index IX_Name on XLockShareCluster(Name)

update XLockShareCluster
        set name='B'
        where ID=1

update XLockShareCluster
        set name='C'
        where ID=2

go

update statistics XLockShareCluster

use Test
go
select * from XLockShareCluster  where ID=1

use Test
go
select * from XLockShareCluster with(holdlock) where ID=1