azuredatastudio icon indicating copy to clipboard operation
azuredatastudio copied to clipboard

Formatting issues

Open bciesielski opened this issue 7 years ago • 0 comments

  • SQL Operations Studio Version: 0.26.7
  1. Formatting doesn't correct case for
    • cast - E.g. after formatting: SELECT cast(1 AS VARCHAR(10))
    • dateadd
    • datediff
    • time intervals used in dateadd, e.g. 'minute', 'month', 'year' etc.
  1. Formatting doesn't work with joins
  • e.g. SELECT * FROM sys.objects o FULL OUTER JOIN sys.tables t ON 1=1 INNER JOIN sys.columns c ON 2=2 result:
SELECT *
FROM sys.objects o FULL OUTER JOIN sys.tables t ON 1=1 INNER JOIN sys.columns c ON 2=2

should be something like

SELECT *
FROM
     sys.objects o 
     FULL OUTER JOIN sys.tables t ON 1=1 
     INNER JOIN sys.columns c ON 2=2

or be configurable where to break the line to be adjustable to personal coding style (a parameter whether to break lines in short, up to x-characters, subqueries/statements would be nice too)

bciesielski avatar Mar 14 '18 21:03 bciesielski