title: How to get the next identity value from SQL Server
body: <p>I need to get the next identity value from <code>SQL Server</code>.</p>
  
  <p>I use this code :</p>
  
  <pre><code>SELECT IDENT_CURRENT('table_name') + 1
  </code></pre>
  
  <p>This is correct, but when the <code>table_name</code> is empty (and next identity value is "1")  returned "2" but <strong>result is "1"</strong></p>