SQL Formatter Options

Stored Procedure Statements

Comma placement for lists that appear in procedural statements – the argument list of a procedure call, an INTO target list, and similar constructs outside a regular SELECT.

Stored Procedure Statements

Statements

ID	Option	What it does	Default
ID243	ProLinebreak Before Comma in Statement SP_LBB_COMMA_STATEMENT	Leading commas in the lists of procedural statements, such as a procedure call's argument list.	`off`
ID244	ProLinebreak After Comma in Statement SP_LBA_COMMA_STATEMENT	Trailing commas in the lists of procedural statements.	`on`
ID247	ProMove Comma 2 Positions to the left with 1 Space (When ID24... SP_ALI_MOVE_COMMALEFT_STMT	Shifts a leading comma two positions left and puts one space after it.	`off`
ID248	ProMove Comma 1 Position to the left with no Space (When ID24... SP_ALI_MOVE_COMMALEFTONE_STMT	Shifts a leading comma one position left with no space after it.	`off`

A SQL Server EXEC call: the parameters follow the procedure name directly, without brackets, which is exactly the kind of list these options govern.

ID244 on (trailing comma)

exec dbo.usp_update_employee
    @emp_nbr   = 4711,
    @emp_name  = 'Smith',
    @dept_nbr  = 10,
    @salary    = 5200.00,
    @hire_date = '2026-01-15';

ID243 on (leading comma)

exec dbo.usp_update_employee
    @emp_nbr   = 4711
  , @emp_name  = 'Smith'
  , @dept_nbr  = 10
  , @salary    = 5200.00
  , @hire_date = '2026-01-15';

Tip: These options apply to lists in procedural statements only – an EXEC or CALL argument list, an INTO target list. The parameter list in a procedure header is on the Procedure & Function Parameters page, and lists inside a regular SELECT are on the Comma Separated Lists page.

Option IDs are identical across all SQLinForm editions (VS Code, JetBrains, SSMS, Notepad++, Online Formatter) and are the keys stored inside a profile file. Generated from properties.json 2026.8.21.0.