Skip to main content

Posts

Showing posts from January, 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

NEW TO BLOGGING

Hi friends new to this all blogging system.........so hoping for good friends if want to comment u can .....so that i can improve my blogs........ And I hope, through this blog I can give some what knowledge that i have gained this many years to all of you. Hope that i like this blogging system............