sqlWorkout

[u/No_Channel_3299]

😌 SELECT 😌

[u/JimyLamisters]

When I started at my current tech job about 12 years ago there was a senior DBA who legit typed all of his emails and chats in uppercase. My dude really pressed caps lock one day and never looked back

[u/fullyonline → u/JimyLamisters]

My dude really pressed caps lock one day and never loocked back

Fixed it for you.

[u/vj2018 → u/JimyLamisters]

LEGEND SAYS IT IS STILL LOCKED TO THIS DAY

[u/EdgeSimilar1726 → u/JimyLamisters]

THIS GOT A HEARTY CHUCKLE OUT OF ME

[u/big_poppa_man → u/JimyLamisters]

LOL

[u/DangerMacAwesome → u/JimyLamisters]

I AM YELLING, CARL

[u/Eleventhousand]

I held shift the entire time for about the first twenty years. Then I just started typing everything in lowercase.

[u/KlausInTheHaus → u/Eleventhousand]

Your left pinky must have been an absolute python.

[u/Eleventhousand → u/KlausInTheHaus]

Now that you mention it, it does look 4% thiccer than my right.

[u/snafe_ → u/Eleventhousand]

Moment of silence for the right shift key, always forgotten.

[u/JackTheKing → u/snafe_]

TIL there is a shift key on the right

. . . and command and option too?!

[u/Sengfroid → u/snafe_]

Genuinely set mine for macros.

And then forget even the macros on it because that's how little the key is used

[u/Mutopiano → u/KlausInTheHaus]

Absolute SQL*

[u/government_ → u/Eleventhousand]

My coworkers hate that I do this because it’s annoying to hold shift or caps on and off constantly. But also, lowercase is a million times easier to read.

[u/hopefullyhelpfulplz → u/Eleventhousand]

I do it in random upper/lowrcase segments cus why not

[u/Eleventhousand → u/hopefullyhelpfulplz]

You are the most enlightened

[u/hopefullyhelpfulplz → u/Eleventhousand]

Tis I! The EnLIghteNEd OnE

[u/jib_reddit → u/Eleventhousand]

I used to write it in lowercase but recently started using upper as I like the "shoutieness" of it.

[u/kagato87]

Naw dog, I hold the shift with my pinky.

My left pinky is ripped!

(OK, not the last one, though it probably is the best at "Hold something down" out of the 10.)

[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.

[u/ibronco → u/chaosink]

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

[u/Joelle_bb]

Lmao

As a person who selectively caps locks depending on context amd emphasis.... can't relate

[u/Key_Tea349]

Working on a query and a random Teams message pops up.

STARTS REPLYING IN ALL CAPS

Backspace, turns off caps lock and switches to sentence case so my coworkers don't think I'm yelling at them.

[u/DaOgDuneamouse]

SELECT * FROM <table name>

I often type most of an email before I realize caps lock is still on.

[u/TechOpsCoder]

Lowercase is the way. It looks so much cleaner and much easier write. Keyboard placement and spacing is the most important thing for readability.

[u/Traceuratops]

Caps for functions, lower case for arguments. Readability is important.

[u/Zestyclose-Turn-3576 → u/Traceuratops]

modern editing environments use colours to differentiate between these anyway

[u/global_namespace]

that's <> true. you can SELECT ANY CASE.

[u/Outrageous_Let5743]

It is even worse at my company. We use lowercase keywords but UPPERCASE COLUMNS. We use SQL server but migrated from a legacy Oracle DB where it could only be capital names.

[u/Zestyclose-Turn-3576 → u/Outrageous_Let5743]

Really? I started with Oracle in the early 1990s, and I don't think that was a thing then. Though there were practitioners who swore it made the system faster 🙄

[u/Herb_marqz]

MF DOOM HAS ENTERED THE CHAT

[u/Infini-Bus]

Write sloppy sql.  Then auto format 😀

But it always feels more natural to me to just hold the shift key than toggle caps lock.

[u/boxerrox]

lowercase supremacy

[u/Blomminator]

Don't mock my job!

[u/Due-Championship3941]

Lower case the commands and upper case the nouns or visa versa. Improves readability.

[u/ewoolly271]

Erm actually per dbt sql standards they recommend lowercase 🤓

[u/TheoreticalUser]

I have about 15 years working in/on databases for a ton of different types of implementations.

If I see all caps, all the time... I'm judging you on a lack of adaptability. And frankly, your skill level.

[u/Zestyclose-Turn-3576]

Lower case, and you better be aligning that code ... reduced visual complexity wins for human readability ...

      Case
        When crs.price_basis  like 'Escalator%' then crs.id
        when mrs.price_basis  like 'Escalator%' then mrs.id
        when brs.price_basis  like 'Escalator%' then brs.id
        When wcrs.price_basis like 'Escalator%' then wcrs.id
        when wmrs.price_basis like 'Escalator%' then wmrs.id
        when wrs.price_basis  like 'Escalator%' then wrs.id
      end price_escalator_specifier,      Case
        When crs.price_basis  like 'Escalator%' then crs.id
        when mrs.price_basis  like 'Escalator%' then mrs.id
        when brs.price_basis  like 'Escalator%' then brs.id
        When wcrs.price_basis like 'Escalator%' then wcrs.id
        when wmrs.price_basis like 'Escalator%' then wmrs.id
        when wrs.price_basis  like 'Escalator%' then wrs.id
      end price_escalator_specifier,

[u/Dead_Parrot]

Write it any damn way you please then let poorsql make it easy for others to read

[u/rickulele]

I use lowercase so I can differentiate what I typed directly vs what SSMS auto-generates in “Script View as…”

[u/Quick-Ad1830]

I had a script that changed all sql statements to all lower case when changes were submitted to be promoted. So much easier to read.

[u/Far_Swordfish5729]

You know, sql is generally case invariant. Some idiot just decided they liked it that way. I decided C was here first and I like lower case and pascal case table and column names. I was never told I was wrong. I set a trend actually. You can also just write sql as you would code.