At one point, I created a demo script whereby one could retrieve the next value in a SQL Server 2012 sequence and use that value in a UNION ALL clause. That worked up to and including CTP 3. It never worked with plain UNION. I never tested it on RC0, but now, in SQL Server 2012 RTM, this is no longer supported.
SQL Server Tips · · · ·