Follow @RoyOsherove on Twitter

SQL Server is Missing NextVal Functionality

I really like working with SQL server, but there is one feature that's missing that I can;t understand why: Sequences.

  •  In ORACLE, I could do a "Table.NextVal" to get the value of the next insert unique ID.
  • In SQL Server - I have nothing but @@IDENTITY to go with, but I can only get the Current IDENTITY. This is causing some of our stuff some real trouble.


Anyone know if there's a way to implement NextVal functionality in SQL server? we've been fighting with this all day.... :(

Is there something we're missing here?

Very Good Winforms FAQ

Free Full Tech Books