title: How do I get row id of a row in sql server
body: <p>I have one table <code>CSBCA1_5_FPCIC_2012_EES207201222743</code>, having two columns <code>employee_id</code> and <code>employee_name</code></p>
  
  <p>I have used following query </p>
  
  <pre><code>SELECT ROW_NUMBER() OVER (ORDER BY EMPLOYEE_ID) AS ID, EMPLOYEE_ID,EMPLOYEE_NAME 
  FROM CSBCA1_5_FPCIC_2012_EES207201222743 
  </code></pre>
  
  <p>But, it returns the rows in ascending order of <code>employee_id</code>, but I need the rows in order they were inserted into the table.</p>