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

Tuesday, January 11, 2011

The Adventures of Sherlock Holmes

The Adventures of Sherlock HolmesThe Adventures of Sherlock Holmes

Sunday, January 9, 2011

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............