Friday, January 28, 2011

issues about rowlock in sql.......



suppose if i am using rowlock in following manner

SELECT OrderID
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