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

goosvanbeek

Hi support,

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


SSMS 13.0.16106.4
SQL Prompt 7.5.1.1000

Best regards,
Goos van Beek.

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.

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.

Russell D

Thanks for just clarifying that - I'll raise it with the team.

goosvanbeek

After upgrading to SQL Prompt 8, 'formatting off' works as expected.