Posts
Sort by recent activity
SQL Prompt Formatting Off doesn't apply to itself
The indentation of the Off/On switches move around when formatting SQL.
Original query:
-- SQL Prompt Formatting Off
SELECT * FROM INFORMATION_SCHEMA.COLUMNS c
-- SQL Prompt Formatting On
Fo...
SQL Prompt Formatting Off not applying to a VALUES construct
Using the new switch 'SQL Prompt Formatting Off' to keep a list of attributes in a VALUES constructor from being formatted, I noticed that the comments I'd placed between statements are being moved...
Inconsistent new line behavior with windowed function
I've noticed that the ORDER BY list items within a windowed function do not follow the normal "Place first item on new line" settings. The following query was formatted using the "If there are sub...
Add/remove alias definition
The new format action for applying column alias style is simply incredible: as one of the people that submitted requests for that, let me say thank you!
Is there a way to extend this functionality ...
Inconsistent new line behavior with VALUES clause
The settings for the VALUES clause does not seem to be correctly determining when to insert a new line, depending on the 'Commas' option within lists.
If I set Global --> Lists --> Commas --> Place...
Parenthetical Indentation within a CASE expression
Most of the new indentation options are awesome, but I've seen some strange behavior with parentheses. In the query below, shouldn't the 'IN' list be indented from the CASE?
SELECT Field = CASE
...
Inconsistent new line behavior with comments
I make frequent use of comment blocks to separate logical portions of a script (/*Comment*/).
I've noticed that SQL Prompt will sometimes reformat things to start after a comment line, such as the ...
Aliased function result breaks wildcard expansion
I've hit on a very odd behavior with SQL Prompt. As nearly as I can tell, the wildcard expansion / All non-aggregated columns options are both confused by the presence of an aliased aggregation of...
"New line" behavior in the FROM clause
Under Global --> Lists --> List Items, I have the "Place first item on new line" option set to "if there are subsequent items".
When I try to format the following query, the first table name in my ...
List "new line" behaviour not consistent with TOP operator
Under Global --> Lists --> List Items, I have the "Place first item on new line" option set to "if there are subsequent items" (note: brief test shows the same issue applies when this is set to "al...