latitiacasta (10/20/2016)
I have requirement when one transaction select records and update status same time another transaction also do the same thing. I have put (nolock ) in select query and isolation level is readcommited. is there any other thing is require? Please suggest.
Study up on concurrency. Most database applications are inherently multiuser, so a basic understanding on how databases and applications handle multiple users possibly accessing and updating the same records goes a long way.
You could go here:
http://www.sqlservercentral.com/Books/
and check out the book "SQL Server Concurrency: Locking, Blocking and Row Versioning" or maybe google some terms and do some reading up.