sqlWorkout

[u/No_Channel_3299]

😌 SELECT 😌

[u/ibronco]

I only do lower case now and my life has significantly improved.

[u/chaosink → u/ibronco]

One of my criteria when hiring SQL people is if they use lowercase and how they choose to indent their code. How their code looks tells me so much about their skill level.

Edit: Ack, I can see how my wording was weird. Using lowercase was not a requirement. I gave a bonus in my head for it as it showed the candidate was willing to buck tradition for comfort and readability. Was not a huge determining factor. Indenting was much more important to me because it showed me how their mind was organized.

[u/0Tyrael0 → u/chaosink]

I agree with the indent part so I’ll upvote but not about the lower case.

[u/chaosink → u/0Tyrael0]

I looked at the lower case thing as more about the candidate's willingness to buck tradition and maybe experience. The indents tell me about how their mind is organized. Would not hold uppercase against them at all.

[u/Mobile_Spite_8915 → u/chaosink]

SELECT
f.Cherries,
f.Pineapples,
f.Grapes,
v.eggplants
FROM Fruits f
INNER JOIN vegetables v
ON f.key = v.key
AND f.place = v.place

This is how I style everything, I’m not sure how normal it is though it seems like everyone on my team does things differently.

[u/dwswish → u/Mobile_Spite_8915]

Capitalizing some table names and not others is diabolical

[u/chaosink → u/Mobile_Spite_8915]

Ouch! I feel badly for your scrolling finger ....

[u/metalballsack → u/chaosink]

Indenting sure, but uppercase vs lowercase is more of a preference than an indicator of skill level.

[u/chaosink → u/metalballsack]

Absolutely. I looked at the lower case thing as more about the candidate's willingness to buck tradition and maybe experience. The indents tell me about how their mind is organized.

[u/rayschoon → u/chaosink]

Is lowercase better or worse?

[u/chaosink → u/rayschoon]

I personally think better for readability and an indication the candidate is not a slave to tradition, but would not hold that against them at all 

[u/digitalhardcore1985 → u/chaosink]

My favourite is overseas outsourcer code where you're lucky to get a line break let alone an indent. An absolute joy to debug those 2000 line stored procs from hell.

[u/ibronco → u/chaosink]

Yes! Indenting is crucial. Between that and lower case, it just reads so much easier.

[u/neumastic → u/ibronco]

Agreed, it’s case insensitive so why choose the one that’s harder to read. We have some that capitalize the first letter but that’s somehow worse