suppose if i am using rowlock in following manner
FROM Orders WITH( holdlock , ROWLOCK)
WHERE OrderID =100
then can u please tell me ..... untill how much it will hold this lock . because as soon as i execute this query ; simultaneously i can select the same query from another page. that means it is not holding a lock ...
SO PLEASE ME HELP OUT.......
PLEASE REPLY ME AS SOON AS POSSIBLE
THANKS IN ADVANCE