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
![](https://secure.gravatar.com/avatar/0bc5ae6a6da11de32427cc261a74913a?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
-
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?