Search
-
Re: Formatting requests - post them here
This is a nice-to-have kind of thing that would comfort the compulsive side of me. I would like to always have trailing spaces removed, or at least have it as an option. simplistic example: before:IF 1 = 1 BEGIN SELECT t.* FROM dbo.Foo WHERE t.bar = 'zee' END ELSE BEGIN SELECT t.* FROM dbo.Zee WHERE t.bar = 'foo' END… -
Re: Formatting requests - post them here
I would like an option to force a simple IF EXISTS() condition to ONE line. Example: Where exists ( Select * from @TMMSale T Where T.MaxAkey=D.a_Key ) and D.a_Type='I' Instead, I would prefer the following:Where exists ( Select * from @TMMSale T Where T.MaxAkey=D.a_Key ) and D.a_Type='I' I prefer this because my if exists… -
Re: Formatting requests - post them here
Comment by willspurgeon · · Home› Discontinued and Previous Versions› SQL Refactor Previous VersionsI RADICALLY second this comment. To put the joined table on the new line is my #1 feature request for SQL Layout. My final style ends up as: SELECT F.FieldA, S.FieldB, T.FieldC FROM FirstTable FINNER JOIN SecondTable S ON F.Key1 = S.Key1INNER JOIN ThirdTable T ON S.Key2 = T.Key2 Having the join table on a new line and…
3 results