Formatting Issue - Alignment of Equals Signs "=" on JOINs

AndrewJacksonZA

Hello

I'm using SSMS17.1 with SQL Prompt 8.0.4.1638.

Either I'm missing something extremely obvious or you've got a usability issue with your new formatting styles: I can't find where to change the equals sign alignment option for my custom style.

Currently the joins get formatted to this, which irritates me to no end and lowers the readability of my own code:

    INNER JOIN ABC.Bob AS b ON a.SomeID                             = b.ID
    INNER JOIN GT.TableName AS tn ON b.BlahID                       = tn.ID
    INNER JOIN FGH.AReallyLongValidTableName AS arlvtn ON tb.LalaID = arlvtn.ID

I want it to be this:

    INNER JOIN ABC.Bob AS b ON a.SomeID = b.ID
    INNER JOIN GT.TableName AS tn ON b.BlahID = tn.ID
    INNER JOIN FGH.AReallyLongValidTableName AS arlvtn ON tb.LalaID = arlvtn.ID

Searching for "=" and "equal" in your search box doesn't help me.

Where do I change this setting please?

Thank you,
Andrew

James R

Hi @AndrewJacksonZA ,

Thanks for your post! I think the option you're looking for is under Expressions > Operators > Comparison and arithmetic > Align comparison operators.

I think it would make a lot of sense for a search for "equals" or "=" to highlight this, so we'll try to get that working soon.

Please let us know if that works for you.
Regards,
James

AndrewJacksonZA

Thanks James, sorted! :-)

This would really make sense to me as a formatting option for JOINs, as well as a separate formatting option for things like variable declarations and usage.

Thank you,
Andrew