Difference between locking techniques

Hi,
i am posting this question 2nd bcz it was not asnwered, so plz don't mind it

Whats the difference between

[adlockreadonly,adlockpessimistic,adlockoptimistic,adlockbatchoptimisitc]

and

[tablock, rowlock]

:wave: Zafar,

Please refer the following link.. if u wanna know more abt it refer to MSDN


http://docs.sun.com/source/817-2514-10/Ch11_ADO113.html

Hope this explains

Hey zafar,

This following link is much more comprehensive .. ignore the previous post..

http://dev.mysql.com/tech-resources/...and-locks.html