PoorMansTSqlFormatter
PoorMansTSqlFormatter copied to clipboard
Add support/highlighting for SQL Server 2012-17 T-SQL enhancements
- T-SQL enhancements:
-
OFFSETandFETCH NEXT/FETCH FIRSTpaging -
THROWstatement in exception handling - new
SEQUENCEobject- Related DDL, eg
CREATE SEQUENCE - Related DML, eg
NEXT VALUE FOR SomeSequence
- Related DDL, eg
- Windowing
ROWandRANGEkeywords- Related
PRECEDING/FOLLOWING,UNBOUNDED PRECEDING/UNBOUNDED FOLLOWINGandCURRENT ROWspecifiers
- Related
- Windowing
LAG()andLEAD() - Execute...
WITH RESULT SETSclause -
FORCESCANandFORCESEEKhint keywords - String manipulation functions
Format()andConcat() - Logical functions
Iif(), andChoose() - Type conversion functions
Parse(),Try_Parse(), andTry_Convert() - New DateTime functions (
EOMonth(), etc) - Other new analytical functions
-
Percent_Rank() -
Cume_Dist() -
First_Value() -
Last_Value()
-
-
@alexandermou also mentions, in duplicate issue #115, "iif() grouping() rollup etc"
@albyrock87 linked, in Issue #179, to official T-SQL language docs!!
https://docs.microsoft.com/en-us/sql/t-sql/language-reference https://docs.microsoft.com/en-us/sql/t-sql/queries/queries https://docs.microsoft.com/en-us/sql/t-sql/statements/statements
Also CREATE OR ALTER syntax for SQL Server.