tag:blogger.com,1999:blog-4637916344259831631.post7505452794237134154..comments2011-02-03T05:46:14.388-08:00Comments on All about LIFE, WORK, AND EVERYTHING: issues about rowlock in sql.......Prijesh Ramanihttp://www.blogger.com/profile/11198876870927432584noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-4637916344259831631.post-44853800594893983552011-02-03T05:46:14.388-08:002011-02-03T05:46:14.388-08:00chirag I hav done that but it doesn't allows o...chirag I hav done that but it doesn't allows other user on lan to select other row from the same row...................<br />but i got da solution which UPDLOCK with Row lock ...............<br />thanks chirag...........Prijesh Ramanihttps://www.blogger.com/profile/11198876870927432584noreply@blogger.comtag:blogger.com,1999:blog-4637916344259831631.post-86916960281542270552011-02-03T03:57:05.167-08:002011-02-03T03:57:05.167-08:00it will hold the lock till u commit the transactio...it will hold the lock till u commit the transaction & here u havent started any transaction<br /><br />Begin transaction !!!<br />-RegardsChiraghttps://www.blogger.com/profile/06035156451624874613noreply@blogger.comtag:blogger.com,1999:blog-4637916344259831631.post-81415361233534349792011-02-03T02:28:51.234-08:002011-02-03T02:28:51.234-08:00hey anyone please help me outhey anyone please help me outPrijesh Ramanihttps://www.blogger.com/profile/11198876870927432584noreply@blogger.com