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

'SQL Prompt formatting off' doesn't seem to work

Hi support,

My code is still formatted when using 'SQL Prompt formatting off'
pe9478i0l9b7.png

SSMS 13.0.16106.4
SQL Prompt 7.5.1.1000

Best regards,
Goos van Beek.
goosvanbeek
0

Comments

4 comments

  • Russell D
    Did you format the SQL first, and then choose to disable formatting on the highlighted code? If so this doesn't work, you need to select the code you don't want formatting and disable formatting first, then format the rest of the sql.

    In the documentation it does say 'This code now won't be formatted when you run Format SQL.', but I'll see if we can make this any clearer.
    Russell D
    0
  • goosvanbeek
    Hi Russel,

    Thanks for your reply.
    Tried it both the ways you suggested, see the gif's below. Both with the same result. I expected the indention won't be formatted.

    Regards,
    Goos.
    e44yvpq76x9o.gif

    31td4tsad0fx.gif



    goosvanbeek
    0
  • Russell D
    Thanks for just clarifying that - I'll raise it with the team.
    Russell D
    0
  • goosvanbeek
    After upgrading to SQL Prompt 8, 'formatting off' works as expected.
    goosvanbeek
    0

Add comment

Please sign in to leave a comment.