title: Concurrent updates handling in ASP.NET or SQL Server 2008
body: <p>There is a table called <code>Accounts</code> that looks like this:</p>
  
  <pre><code>AccountID   AccountName   AccountTotalMoney
  -------------------------------------------
    1           Steven           600
    3           Scott            800
  </code></pre>
  
  <p>But users can updates the row record at the same time like below now:</p>
  
  <pre><code>User A:UPDATE Accounts SET AccountTotalMoney=700 WHERE AccountID=1;
  User B:UPDATE Accounts SET AccountTotalMoney=900 WHERE AccountID=1;
  User C:UPDATE Accounts SET AccountTotalMoney=1000 WHERE AccountID=1;
  .
  .
  .
  </code></pre>
  
  <p>So I would like to prevent multiple users updating the same record at the same time .
  Just one after another.</p>
  
  <p>I am a newbie in this aspect. Sorry for my bad english. Thanks in advance!</p>