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

TaoK / PoorMansTSqlFormatter

A small free .Net and JS library (with demo UI, command-line bulk formatter, SSMS/VS add-in, notepad++ plugin, winmerge plugin, and demo webpage) for reformatting and coloring T-SQL code to the user's preferences.

http://www.architectshack.com/PoorMansTSqlFormatter.ashx

GNU Affero General Public License v3.0

946 stars 266 forks source link

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

Open TaoK opened 12 years ago

TaoK commented 12 years ago

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 commented 6 years ago

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

TaoK commented 6 years ago

@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

Vortexel commented 5 years ago

Also CREATE OR ALTER syntax for SQL Server.