Missing formatting options
Already the best formating add-in, but please make it truly complete with these few additions (some are from ApexSQL Refactor) to make it really perfect, thanks.
Line break immediately after WHEN, WHILE, IF keywords (to be more consistent like WHERE, HAVING, ON), and then indent their conditions.
Do not use a line break before the first item (or remove the existing one) if there is only one item (like SELECT with only one column).
Always use BEGIN / END for IF / ELSE, WHILE (add if missing).
Always use INTO for INSERT (add if missing).
Always use AS for aliases (add if missing).
Always use a statement terminator (add ";" at the end if missing).
-
pOcHa commented
As well as the missing INNER or OUTER keyword for a JOIN.
-
pOcHa commented
And add the missing BEGIN / END around a stored procedure body.
-
pOcHa commented
Also, if you could add line break before CASE always (not just on right-hand operands), that would be great.