title: Concurrency handling of Sql transactrion
body: <p>Suppose, I am about to start a project using ASP.NET and SQL Server 2005. I have to design the concurrency requirement for this application. I am planning to add a TimeStamp column in each table. While updating the tables I will check that the TimeStamp column is same, as it was selected.</p>
  
  <p>Will this approach be suffice? Or is there any shortcomings for this approach under any circumstances?</p>
  
  <p>Please advice.</p>
  
  <p>Thanks</p>
  
  <p>Lijo </p>