sql formatter option: how to place a comma in the list of parameter in execute statement
This format option controls where to put comma in the list of parameters of SQL Server execute statement. a line break can be placed after comma, or before comma
name: exec_parameters_comma_option, default is put line break after comma
setting path: Execute -> parameter comma option
EXEC Spr_store_note
@NoteId = 0,
@TableTypeId = @TABLE_CUSTOMER,
@RecordId = @CustomerId,
@Descr = @Comments
After set exec_parameters_comma_option to “before comma”, SQL will be formatted like this:
EXEC Spr_store_note
@NoteId = 0
,@TableTypeId = @TABLE_CUSTOMER
,@RecordId = @CustomerId
,@Descr = @Comments
After set exec_parameters_comma_option to “before comma with a space”, SQL will be formatted like this:
EXEC Spr_store_note
@NoteId = 0
, @TableTypeId = @TABLE_CUSTOMER
, @RecordId = @CustomerId
, @Descr = @Comments