Skip to main content

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

Comments

  1. Prijesh RamaniFebruary 3, 2011 at 2:28 AM

    hey anyone please help me out

    ReplyDelete
  2. ChiragFebruary 3, 2011 at 3:57 AM

    it will hold the lock till u commit the transaction & here u havent started any transaction

    Begin transaction !!!
    -Regards

    ReplyDelete
  3. Prijesh RamaniFebruary 3, 2011 at 5:46 AM

    chirag I hav done that but it doesn't allows other user on lan to select other row from the same row...................
    but i got da solution which UPDLOCK with Row lock ...............
    thanks chirag...........

    ReplyDelete

Post a Comment

Popular posts from this blog

Solution for Candy Crush Facebook error "Cannot connect to facebook. you do not have access"

This is for iphone If you are getting the following error in candy crush while connecting to facebook. And if you are ahead in iphone with more levels than facebook then do the following it is 100% working solution 1. first download the following app http://www.macroplant.com/iexplorer/ 2. Now connect your iphone and open the iexplorer app. In this in app section search for candy crush. 3. Right click on candy crush folder and export it on your drive. This will backup your current candy crush on your PC. 4. Now delete the candy crush app from your mobile and download and install again. 5. After installing start the candy crush and it will ask you to connect to facebook, and it will sync all the level of facebook. 6. So now to get to the previous level you again have to connect iphone to pc and open iexplorer app and search for candy crush app. 7. Now in iexplorer go to Candy Crush\Documents and click to import and browse to the same folder in your pc and ...
Post a Comment
Read more

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............
2 comments
Read more