Formatting exec statements

Hi,

I would like to format EXEC statements all on one line, unless they exceed 120 characters. I would like to format longer EXEC statements with one parameter per line. Can SQL Assitant do that?

Maximum line length and line wrapping options are defined at the formatting style level, not at the statement formatting rule level. You cannot choose to wrap EXEC lines after 120 characters and SELECT lines after 80.

Aside from that, to customize formatting specific to EXEC statement, use the EXEC formatting rule in one of T-SQL formatting styles, whichever you use. Position of procedure parameters is controlled parameter placeholders within that rule. If you specify them on the same line, they will appear on the same line then wrap as specified length in the rapping options for the style. If you specify them on separate lines, they will appear on separate lines.