title: what is locking in sql server?
body: <p>can anyone please help me to understand the concept of locking in sql server?
  What i understand is, it prevents others from using the locked data.
  What each type of locks do?
  what is more about it with examples?</p>