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

Formatting style: Indenting subqueries question

Hello,

Currently, when I format my query, the exists subquery is not left aligned with the And operator. Is there a setting to force it align with the AND keyword?


I scoured through all the settings and I didn't find anything, but maybe I missed it.

And one more thing, I noticed that after I made Formatting style changes and saved them, I had to restart SSMS to make them effective. Is it normal? Imo, the changes should be effective immediately.

Thanks




Bog
0

Comments

3 comments

Sort by
  • Dan_J
    Hi @Bog

    Thanks for reaching out to us regarding this.

    Are you able to achieve the formatting you are after using the AND/OR operator settings shown in the screenshot below?



    Regarding having to restart SSMS are formatting style changes, this shouldn't be necessary. What version of SQL Prompt are you currently using?



    Dan_J
    0
  • Bog
    Hi @Dan_J,

    Firstly, I upgraded to 10.6.1 yesterday.

    re: formatting subqueries - that's what I use and the subqueries are not aligned properly. I just tried again and the subquery is aligned with the WHERE keyword in the query. Imo, it should be aligned with the AND operator or perhaps indented with one step.

    re: saving the formatting style changes - they fixed the issue in 10.6.1. So it's all good.
    Bog
    0
  • Dan_J
    Hi @Bog

    My sincere apology for the delay in responding to you regarding this!

    So that I can best troubleshoot this, would you be happy to provide me with a copy of your script and format style file?


    Dan_J
    0

Add comment

Please sign in to leave a comment.