title: Alternate for select <sequence>.nextval from dual of Oracle in SQL Server?
body: <p>Is there any way to create a unique sequence no in SQL Server</p>
  
  <pre><code>select &lt;sequence&gt;.nextval from dual
  </code></pre>
  
  <p>We have the above code for Oracle which will create a unique number and the number cannot be used by any other.</p>
  
  <p>In the same way how can I create a unique sequence number in SQL Server????</p>
  
  <p>Some one help me in this</p>