How can we help you today? How can we help you today?

Formatting style - BUG (case when)

There seems to be a bug when formatting the following code:
<div>DECLARE @date datetime = NULL</div><div>SELECT @date = CASE WHEN @date IS NULL THEN GETDATE()ELSE @date END</div>
In this case there is a problem with spaces,
and it seems that the Formatter does not refer to settings, such as a new line etc.
Isaac bar Nisan
0

Comments

1 comment

Sort by
  • DustinM
    Hello,

    Thank you for your inquiry into SQL Prompt, we are sorry to hear it is giving you trouble.

    Would you be able to tell us which version of SQL prompt you are currently using?

    Regarding the sample query provided are you keeping the <div></div> in place while attempting to format? Would you also be able to provide a screenshot of the output when formatting?

    Best,

    Dustin
    DustinM
    0

Add comment

Please sign in to leave a comment.