SQL Server 2012: SEQUENCE Feature RTM restrictions and update

Hi Friends,

I had written a series of blog posts on the SEQUENCE feature in DENALI (now SQL Server 2012). You can browse them here:

https://www.sqlservergeeks.com/sql-server-2012-denali-series-sequence-object/

https://www.sqlservergeeks.com/sql-server-2012-denali-series-sequence-object-part-2/

https://www.sqlservergeeks.com/sql-server-2012-denali-series-sequence-feature-part-3-re-seeding-restarting-incrementing-cycling/

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:

•             DISTINCT

•             UNION / UNION ALL

•             EXCEPT

•             INTERSECT

•             TOP

•             OFFSET

It will also not work with the following conditional expressions:

•             CASE

•             CHOOSE

•             COALESCE

•             IIF

•             ISNULL

•             NULLIF

Please refer Books Online for latest updates before you try out the scripts from any of my blogs posts.

Comments are welcome.