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?