SQL Server is Missing NextVal Functionality

By Roy Osherove In Off Topic

Markdown version

Historical article · Originally published June 18, 2003; technical details may be outdated.

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?

More in Off Topic

All posts in Off Topic