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?