So far after playing around with SQL Server 2012 there are many new features to SQL. Overall I think my favorites are in the Analytic Functions category. Here is my breakdown of the top 10 transact SQL enhancements to SQL Server 2012.
10. New SEQUENCE object
8. Analytics – Analytic Functions – PERCENT_RANK
7. Analytics PERCENTILE_DISC and PERCENTILE_CONT
5. TSQL Analytic Functions LEAD and LAG
4. OVER clause with ROWS PRECEDING and FOLLOWING in TSQL 2012
3. OFFSET / FETCH in a SELECT statement
2. LAST_VALUE and FIRST_VALUE
Whats your favorite?