sql formatter option: first parameter of execute statement in new line

This format option controls whether put a blank line before the first parameter of SQL Server execute statement.

name: exec_first_paramater_in_newline, default is true

setting path: Execute -> first parameter in newline


EXEC Spr_store_note

  @NoteId = 0,

  @TableTypeId = @TABLE_CUSTOMER,

  @RecordId = @CustomerId,

  @Descr = @Comments 

 

After set exec_first_paramater_in_newline to false, SQL will be formatted like this:


EXEC Spr_store_note @NoteId = 0,

                    @TableTypeId = @TABLE_CUSTOMER,

                    @RecordId = @CustomerId,

                    @Descr = @Comments 

Newsletter Updates

Enter your email address below to subscribe to our newsletter