PoorMansTSqlFormatter icon indicating copy to clipboard operation
PoorMansTSqlFormatter copied to clipboard

Add support/highlighting for SQL Server 2012-17 T-SQL enhancements

Open TaoK opened this issue 12 years ago • 3 comments

  • 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()

TaoK avatar Mar 12 '12 15:03 TaoK

@alexandermou also mentions, in duplicate issue #115, "iif() grouping() rollup etc"

TaoK avatar Nov 05 '17 22:11 TaoK

@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

TaoK avatar Nov 07 '17 09:11 TaoK

Also CREATE OR ALTER syntax for SQL Server.

Vortexel avatar Jan 11 '19 00:01 Vortexel