General SQL Parser and SQL Pretty Printer Formatter options

Index

Available format options for comments:

remove_comment	Type: Boolean	Default: false
--begin_no_format, sql after this comment is not formatted	Type: None	Default: None
--end_no_format, sql before this comment is not formatted	Type: None	Default: None

---

Original SQL:

CREATE PROCEDURE uspnresults
AS
SELECT COUNT(contactid) FROM person.contact
--begin_no_format
SELECT COUNT(customerid) FROM sales.customer;
--end_no_format
GO


---

Formatted SQL:

CREATE PROCEDURE Uspnresults 
AS 
 SELECT Count( contactid ) 
 FROM   person.contact 

--begin_no_format 
SELECT Count(customerid) FROM sales.customer;
--end_no_format 
GO