TaoK/PoorMansTSqlFormatter — Issue #23: Add "Denali" support 
Author: TaoK
Created: 2011-10-10 07:56:43+00:00
State: open

* SSMS "Denali" Add-in support (no longer uses obscure registry keys but now standard VS add-in system instead)
* T-SQL enhancements:
* `OFFSET` and `FETCH NEXT`/`FETCH FIRST` paging
* `THROW` statement in exception handling
* new `SEQUENCE` object
* Related DDL, eg `CREATE SEQUENCE`
* Related DML, eg `NEXT VALUE FOR SomeSequence`
* Windowing `ROW` and `RANGE` keywords
* Related `PRECEDING`/`FOLLOWING`, `UNBOUNDED PRECEDING`/`UNBOUNDED FOLLOWING` and `CURRENT ROW` specifiers
* Windowing `LAG()` and `LEAD()`
* Execute... `WITH RESULT SETS` clause
* `FORCESCAN` and `FORCESEEK` hint keywords
* String manipulation functions `Format()` and `Concat()`
* Logical functions `Iif()`, and `Choose()`
* Type conversion functions `Parse()`, `Try_Parse()`, and `Try_Convert()`
* New DateTime functions (`EOMonth()`, etc)
* Other new analytical functions
* `Percent_Rank()`
* `Cume_Dist()`
* `First_Value()`
* `Last_Value()`

There's enough here for multiple releases...