2
Answers

when to use with(nolock) and with(rowLock) in sql server

when to use with(nolock) and with(rowLock) in sql server 2008.
 and what is the advantage and disadvantages of using this.
and what impact on performance  of application of using this.
 
i am getting error :- transaction process id was deadlocked on lock resources with another process  and has been detect as deadlock victiom

Answers (2)