Guido
Guido
@admin
Admin
Member
Joined: Dec 13, 2021
Last seen: Oct 28, 2025
Topics: 4 / Replies: 257
Reply
RE: Smart alignment -- ON plus AND/OR

I can't see any AND/OR keywords in the ON clauses. Please add a few AND/OR clauses and it should work

10 months ago
Reply
RE: Smart alignment -- ON plus AND/OR

@lompies , @hwmonkey When you have some free time, you can test it by downloading the new Release (Desktop app or N++ Plugin) and use the higlighted...

10 months ago
Reply
RE: Smart alignment -- ON plus AND/OR

@lompies , @hwmonkey it took some time but now I have changed the logic for the AND/OR Alignment for JOIN Statements as required. Would you like t...

10 months ago
Reply
RE: River vertical space concept as seen on www.sqlstyle.guide

Hi, finally I go some time to study the white space "river" concept. I will create a beta version. Would you be able to do some beta testing? Regard...

12 months ago
Reply
RE: + 0 Option on SQL>SQL Lists > # Vals on Line 1

Hi @nicholasd, it took some time but now your idea is available for N++ Plugin and Stand-Alone App Regards Guido

12 months ago
Reply
RE: + 0 Option on SQL>SQL Lists > # Vals on Line 1

OK, I will add an option for linebreaks before/after the bracket and to indent the values like in the screenshot for keyword1, keyword2 and keyword3

1 year ago
Reply
RE: + 0 Option on SQL>SQL Lists > # Vals on Line 1

Hi @nicholasd, thanks for your feedback. Which DB are you working with and could you please one example Thanks Guido

1 year ago
Reply
RE: A few suggestions and Issues

Hi @mythas, thanks for your feedback. For the last post (square brackets), did you choose the correct DB (e.g. SQL Server)? Regards Guido

1 year ago
Reply
RE: Smart alignment -- ON plus AND/OR

Hi @hwmonkey, when a linebreak is inserted beforte AND/OR in a JOIN statement it starts at the left margin or at (left margin + one indent level). I...

1 year ago
Reply
RE: River vertical space concept as seen on www.sqlstyle.guide

could you please increase the number of indent spaces from "2" to "6" or "8" and give it a try

1 year ago
Reply
RE: Keywords and "My Upper/Lower Case Keywords"

the INSERT/UPDATE/DEL options work also for the INSERT/UPDATE/DELETE statements inside a MERGE statement

1 year ago
Reply
RE: Cannot remove extraneous white space inside brackets

@agwillow, there is a new option which should do the trick.

1 year ago
Reply
RE: Keywords and "My Upper/Lower Case Keywords"

@jasonccrane, please give the new Release a try. there is now a section for the MERGE and also the 999 cols/line are available

1 year ago
Reply
RE: Over-Indenting of statements

it will be easier to follow up different questions/issues when they are in different tickets Thanks Guido

1 year ago
Reply
RE: Over-Indenting of statements

Hi @cmputrace, the strange formatting comes from the fact, that the formatter breaks the decode in such way that it is aligned below the decode keywor...

1 year ago
Page 4 / 18