title: Query to get the next identity?
body: <p>Query to get the next identity? This is possible for table without deleted records:</p>
  
  <pre><code>SELECT TOP 1 EMPID + 1 FROM Employee ORDER BY EMPID DESC
  </code></pre>
  
  <p>If there is deleted data, How I will get the next identity ? For example I have a table like this:</p>
  
  <pre><code>EMPID    NAME
  4001     someName
  4002     someName
  4003 ----------------------- this is deleted
  4004     someName
  4005     someName
  4006     someName
  4007     someName
  4008     someName
  4009 ----------------------- this is deleted
  4010 ----------------------- this is deleted
  </code></pre>
  
  <p>The ouput must be 4011   </p>