Format SELECT columns. Alias on left, object on right separated by aligned " = ".
Format SELECT columns. Alias on left object on right separated by aligned " = ".
e.g.
SELECT
ThisIsMyFirstCol = a.Col1
, SecondCol = a.Col2
, AndTheThrid = a.Col3
, ForthCol = b.Col1
, FithCol = CASE WHEN a.col1 = b.col2 THEN 'A'
WHEN a.col2 = b.col3 THEN 'B' END
FROM dbo.tableA AS a
INNER JOIN dbo.tableB AS b
ON a.Col1 = b.Col1
-
Jack commented
We would also prefer aligned equal signs. Currently SQL Complete can align the expression to the right of the equals, but not the equal signs themselves.
-
Stephen commented
Whelp, the HTML text editor did not keep my formatting... is there a way I can upload an image to demonstrate my suggestion?