Inconsistent SQL formatting Follow
Answered
Hello,
Love the product, but am coming from the SSMS / SQL Prompt (RedGate) area. I can't seem to get the SQL formatting to behave consistently no matter what I do.
I've tried all kinds of combinations and options - except for the bizarre indentations happening the remaining SQL formatting is to my liking. But I just can't figure this out.
This is a new stored proc snippet for MSSQL:
1. the set nocount on is oddly indented - can't find any solution for that.
2. After my declarations are done, the next if statement and (3) create temp table are indented.
4. Suddenly, the insert into statement is not indented, as it should be.
5. Back to indentation for some reason?
6. Indentation continues...
Please sign in to leave a comment.
Hello, please provide a full SQL query as text for this procedure to reproduce the issue
No problem; here is a trimmed down version which still displays all the issues.
You can see where the indenting is simply off - no reason for it to suddenly indent.
Thank you.
I've created an issue on our tracker, please follow and vote.