I had written a series of blog posts on the SEQUENCE feature in DENALI (now SQL Server 2012). You can browse them here:
Now that the RTM is out, I have observed a couple of restrictions, some of them that worked in DENALI CTPs; primarily with the NEXT VALUE FOR function. Here is the update:
The NEXT VALUE FOR function will not work with any of these operators:
• UNION / UNION ALL
It will also not work with the following conditional expressions:
Please refer Books Online for latest updates before you try out the scripts from any of my blogs posts.
Comments are welcome.