title: Getting a recordID in my SQL select query
body: <p>I have a simple stored procedure that returns records:  </p>
  
  <pre><code>Select empID, EmpFirstName, EmpLastName from EMPLOYEES  
  </code></pre>
  
  <p>The returned result is:  </p>
  
  <pre><code>    EmpID         EmpFirstName       EmpLastName  
      -----         ------------       -----------  
     30152          John               Smith  
     30114          Tom                Jones  
     56332          Steve              Williams  
     85442          Paul               Johnson  
  </code></pre>
  
  <p>What I need is:  </p>
  
  <pre><code> RecID       EmpID         EmpFirstName       EmpLastName  
   -----       -----         ------------       -----------  
   1      30152          John               Smith  
   2      30114          Tom                Jones  
   3      56332          Steve              Williams  
   4      85442          Paul               Johnson  
  </code></pre>
  
  <p>How can I get the recordID column?</p>
  
  <p>Thanks</p>