General SQL Parser and SQL Pretty Printer Formatter options
Index
Max length of each line for a string concat expression.
this parameter can be ommited if SQL Pretty Printer wise enough to calculate this value
from gfmtopt.LineWidth that depends on where this expression started inside SQL query.
As a workaround, you have to set this value manually.
Example format options:
Formatted SQL:
SELECT 'This' + ' is a sample'
+ ' of the concatination'
+ ' strings that are "nicly"'
+ ' formatted in the orignal code'
+ ' but SQL Pretty Printer'
+ ' puts into one line' + Char(10) + Char(13)
+ 'Please consider how the orignal'
+ ' formatting may be maintained and\or'
+ ' adding options to adjust formatting'
+ ' of strings like this including the'
+ ' use of variables such as the system table name '''
+ name + ''''
+ ' and the char(10) and char(13) line options.'
+ Char(10) + Char(13)
FROM sys.objects