vscode-sql-formatter
vscode-sql-formatter copied to clipboard
Doesn't format some queries properly
I've a query and this tool doesn't format properly. My query is :
WITH n AS ( SELECT T.n FROM ( VALUES (1), (2), (3), (4), (5) ) AS T(n) ) SELECT Cast(N1.n AS VARCHAR(10)) + '\' + Cast(N2.n AS VARCHAR(10)) + ' \ ' + Cast(N3.n AS VARCHAR(10)) FROM (SELECT TOP(5 + Abs(Checksum(Newid())) % 15) n.n FROM n) AS N1 CROSS apply(SELECT TOP(1 + Abs(Checksum(Newid())) % 10) n.n FROM n WHERE N1.n > 0) AS N2 CROSS apply (SELECT TOP(1 + Abs(Checksum(Newid())) % 5) n.n FROM n WHERE N2.n > 0) AS N3;
Also, it doesn't format double @@ signs correctly it puts a space between them like this @ @TRANCOUNT