How to change Formatter options to have SQL statements wrap instead of stack parameters.
Stacked (Default):
Select A;
B,
C
Wrapped:
Select A, B, C
You can change how formatting formats the code by going to View | Formatting Options. Then on the left, select Formatting Options | Specific Statements | SELECT/FETCH/EXECUTE. On the right, select "Wrapped" for "Style of SELECT..." and for "Style of FROM..." Click the Save Icon and run formatting again.
If the parameter values are very long the margins may make it appear as they are still stacked, when actually they are wrapped. You can increase the margin by going to View | Formatting Options | Formatter Options | General Layout | Margins. Increase the Right Margin size so that it'll display more text one a single line.
If you want other parts of the SQL query to be wrapped check off "wrapped" for the other categories. Go through View | Formatting Options | Formatter Options | Lists and Operators. Browse through and change everything to WRAP (Parameter Declarations, Parameters, AND - OR, Plus - Minus - Mul - Div - Concat . and go to Insert, Update, Delete.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy