Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Locking record between SQL statements - Newbie
Suppose I have <br>(a) SELECT a record with a particular field val<br>(b) UPDATE the fieldval on the record so that no other connection uses this record<br><br>How can I effectively lock the row during (a) so that no other connection can access this row till (b) is complete.<br><br>i.e. between...- ramdaskm
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
