General SQL Parser and SQL Pretty Printer Formatter options

Index

Available format options for execute statement:

gFmtOpt.LinebreakBeforeParamInExec

Type: boolean

Default: true

---

Example format options:

Name	Value
gFmtOpt.LinebreakBeforeParamInExec	true
gFmtOpt.IndentLen	2

Formatted SQL:

EXEC Sptrackmember 
  @p_member_id,
  '2.2',
  @p_weeknum 



---

Example format options:

Name	Value
gFmtOpt.LinebreakBeforeParamInExec	false

Formatted SQL:

EXEC Sptrackmember @p_member_id,'2.2',@p_weeknum 



---

Original SQL:

EXECUTE ( 'CREATE TABLE AdventureWorks.dbo.SalesTbl 
(SalesID int, SalesName varchar(10)) ; ' ) AT seattlesales;


---

Formatted SQL:

EXECUTE ( 'CREATE TABLE adventureworks.dbo.salestbl 
             (salesid   INT,
              salesname VARCHAR(10));' ) AT seattlesales;