vscode-sql-formatter icon indicating copy to clipboard operation
vscode-sql-formatter copied to clipboard

Doesn't format some queries properly

Open majidmadadi opened this issue 5 years ago • 1 comments

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;

majidmadadi avatar Feb 06 '20 14:02 majidmadadi

Also, it doesn't format double @@ signs correctly it puts a space between them like this @ @TRANCOUNT

bakert805 avatar Feb 25 '20 14:02 bakert805