title: Multiple instances of a C# Application updating a single MSSQL table
body: <p>We have several instances of our application running at the same time at various places.</p>
  
  <p>And all instances execute an <code>insert or update</code> query on a single table <code>Orders</code>.</p>
  
  <pre><code>Orders
  ---------------------------------------
  
  OrderID OrderDate OrderTime OrderAmount
  </code></pre>
  
  <p>The question is, if all instances of my application <code>insert or update</code> records at the same time, what might happen?</p>
  
  <p>How does MSSQL database handle this scenario?</p>
  
  <p>I googled out and found <code>ROWLOCK, XLOCK, READPAST</code> as a solution on <code>concurrent access to MSSQL database</code> <strong><em>but could not find an exact answer for the above scenario!</em></strong></p>
  
  <p>Any pointers is much appreciated. </p>