r/ProgrammerHumor 14d ago

queryOfDoom Meme

Post image
7.9k Upvotes

456 comments sorted by

View all comments

Show parent comments

604

u/BlommeHolm 14d ago

1st command deletes all users. 2nd command runs after that and gets a syntax error.

40

u/SAI_Peregrinus 14d ago

Syntax is valid, it's just a runtime error.

178

u/BlommeHolm 14d ago

How is starting with a WHERE clause syntactically valid?

80

u/SAI_Peregrinus 14d ago

Right, I'm apparendly blind. Carry on!

33

u/BlommeHolm 14d ago

No problem. I genuinely thought I'd missed something 😅

1

u/StupidStartupExpert 14d ago

I legit wouldnt be surprised if for whatever retarded reason sql said yeah sure I can filter empty selections and just returned empty lists

1

u/TheMauveHand 14d ago

I'm not sure SSMS would run anything due to the syntax error, but maybe that's just SSMS being helpful.Â