PoorMansTSqlFormatter
PoorMansTSqlFormatter copied to clipboard
Add support/highlighting for SQL Server 2012-17 T-SQL enhancements
- T-SQL enhancements:
-
OFFSET
andFETCH NEXT
/FETCH FIRST
paging -
THROW
statement in exception handling - new
SEQUENCE
object- Related DDL, eg
CREATE SEQUENCE
- Related DML, eg
NEXT VALUE FOR SomeSequence
- Related DDL, eg
- Windowing
ROW
andRANGE
keywords- Related
PRECEDING
/FOLLOWING
,UNBOUNDED PRECEDING
/UNBOUNDED FOLLOWING
andCURRENT ROW
specifiers
- Related
- Windowing
LAG()
andLEAD()
- Execute...
WITH RESULT SETS
clause -
FORCESCAN
andFORCESEEK
hint 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.