I'm using SQLPrompt 9.0.6.3580. Formatting CASE statements with negative WHEN values doesn't insert a space between WHEN and the value. For example, here's the result of formatted code:
DECLARE @iv int = -1
SELECT CASE @iv
WHEN 1 THEN 'positive'
WHEN-1 THEN 'negative'
END
Not a huge issue (the code still works), but a bit annoying.
DECLARE @iv int = -1 SELECT CASE @iv WHEN 1 THEN 'positive' WHEN-1 THEN 'negative' ENDNot a huge issue (the code still works), but a bit annoying.