PoorMansTSqlFormatter
PoorMansTSqlFormatter copied to clipboard
TaoK
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...
The "Enable Keyword Standardization" option on poorsql.com ("keywordStandardization" in the library) is misleadingly-named: It should more clearly reflect: - The fact that it is only safe for T-Sql, not for...
- 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...
Instead of: ``` SELECT 1 FROM A WHERE b = c AND d = e ``` optionally have ``` SELECT 1 FROM A WHERE b = c AND d =...
Suggested by Nina Werner
Because inconsistency sucks.
When trying the default Ctrl+K,F in VS 2017, I got this message: The key combination (Ctrl+K, Ctrl+F) is bound to command (Format Selection) which is not currently available. Would it...
Currently the formatter ensure there's a space before a mathematical operator. This causes issue for when formatting bigquery sql which uses - as a space for for project name instead...
As per documentation [here](https://docs.microsoft.com/en-us/azure/sql-database/sql-database-temporal-tables), there is another type of `END` keyword which has no relation to the `END` keyword which terminates block statements. As used in the following example, it...
When I use this tool and sometimes need to format a dynamic sql string like the one below: 'select ''.txt'' as fileExt' and I try to format it wont format...
The default formatting is great. Thumbs up for that. However, I do not like that all functions get expanded, e.g. ``` SELECT id ,CONCAT ( a ,b ) FROM ttable...
