General SQL Parser and SQL Pretty Printer Formatter options
Index
TrueLeft works only following format options set correspondingly,
how to set those format options in sql pretty printer desktop version
Formatted SQL:
SELECT DISTINCT
p.name AS product,
p.listprice AS 'List Price',
p.discount AS 'discount'
FROM production.product p
JOIN production.productsubcategory s
ON p.productsubcategoryid = s.productsubcategoryid
AND p.id = s.id
WHERE s.name LIKE @product
AND p.listprice < @maxprice
AND EXISTS(SELECT *
FROM apps.per_assignments_f asg
WHERE asg.assignment_type NOT IN ( 'B' )
AND b > 1
OR c > 2)
OR p.price = 100;
Formatted SQL:
SELECT DISTINCT
p.name AS product,
p.listprice AS 'List Price',
p.discount AS 'discount'
FROM production.product p
JOIN production.productsubcategory s
ON p.productsubcategoryid = s.productsubcategoryid
AND p.id = s.id
WHERE s.name LIKE @product
AND p.listprice < @maxprice
AND EXISTS(SELECT *
FROM apps.per_assignments_f asg
WHERE asg.assignment_type NOT IN ( 'B' )
AND b > 1
OR c > 2)
OR p.price = 100;