SQL Formatter Option: alignments

SQL Format options index ->Alignment

	align equal sign in set stmt
		gFmtOpt.AL_EqualInSetStmt
			boolean
			default: true
	align set variable in select list
		gFmtOpt.AlignSetVariableInSelectList
			boolean
			default: true
	align alias in select list
		gFmtOpt.AlignAliasInSelectList
			boolean
			default: true
	keyword align in select/delete/insert/update
		gfmtopt.Select_keywords_alignOption
			TAlignOption
				aloLeft
				aloRight
			default: aloLeft

SQL before beautify

SET @SDELETE	= ' '+ LTRIM(RTRIM(@SDELETE)) + ' ' 
SET @ERRORMESSAGE= 'ERROR WHILE CREATING/UPDATING RECYCLE TABLE' 
SET @STABLE	= 'RECYCLE_' + @STABLE 

select @val1 = 1, @var12 = 3

SELECT P.ProductID as 'Product Id', P.Name as 'Product Name', SUM(SD.LineTotal) AS 'YTD Total'
FROM Production.Product AS P

SQL after beautify


SET @SDELETE      = ' ' + Ltrim ( Rtrim ( @SDELETE )) + ' '


SET @ERRORMESSAGE = 'ERROR WHILE CREATING/UPDATING RECYCLE TABLE'


SET @STABLE       = 'RECYCLE_' + @STABLE


SELECT @val1  = 1,

       @var12 = 3


SELECT p.productid          AS 'Product Id',

       p.name               AS 'Product Name',

       Sum ( sd.linetotal ) AS 'YTD Total'

FROM   production.product AS p