title: Query on Identity Column on MS SQL DB
body: <p>I have created table in MS SQL 2008 with one identity column(Start Value - 1 and Increment is also 1) and 4 other columns. I am accessing this DB from C# ASP.NET. Used to push data only for the non identity column. Identity column will auto increment itself.</p>
  
  <p>As of now i am manually querying the column value with the remaining for columns. But I am facing problem if all the other four column values are equal i am not getting the exact value which i am looking for </p>
  
  <p>Now my query is, Is there any why in C# where I can get the value of the newly created identity column whenever new record is created.</p>
  
  <p>Thanks.</p>