General SQL Parser and SQL Pretty Printer Formatter options

Index

Available format options for parameters in function call:

FunctionCall_Parameters_Style	Type: TAlignStyle	Default: asWrapped
FunctionCall_Parameters_Comma	Type: TLinefeedsCommaOption	Default: lfAfterComma

---

Example format options:

Name	Value
FunctionCall_Parameters_Style	asStacked
FunctionCall_Parameters_Comma	lfAfterComma

Formatted SQL:

SET @a = dbo.Func1(@param1,
                   @param2,
                   @param3 + 1,
                   @param4) 

---

Example format options:

Name	Value
FunctionCall_Parameters_Style	asStacked
FunctionCall_Parameters_Comma	lfBeforeComma

Formatted SQL:

SET @a = dbo.Func1(@param1
                   ,@param2
                   ,@param3 + 1
                   ,@param4) 

---

Example format options:

Name	Value
FunctionCall_Parameters_Style	asWrapped
FunctionCall_Parameters_Comma	lfBeforeComma

Formatted SQL:

SET @a = dbo.Func1(@param1, @param2, @param3 + 1, @param4) 

---

Example format options: Layout of decode function doesn't controlled by following format options

Name	Value
FunctionCall_Parameters_Style	asWrapped
FunctionCall_Parameters_Comma	lfBeforeComma

Formatted SQL:

SELECT last_name,
       DECODE(job_id, 'It_prog', 1.10 * salary,
                      'st_clerk', 1.15 * salary,
                      'sa_rep', 1.20 * salary,
                      salary) revised_salary
FROM   employees;