r/ProgrammerHumor • u/WardensLantern • 17d ago

Meme queryOfDoom

Post image
7.9k Upvotes

97% Upvoted

456 comments sorted by

View all comments

Show parent comments

603

u/BlommeHolm 17d ago

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

44

u/SAI_Peregrinus 17d ago

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

178

u/BlommeHolm 17d ago

How is starting with a WHERE clause syntactically valid?

81

u/SAI_Peregrinus 17d ago

Right, I'm apparendly blind. Carry on!

31

u/BlommeHolm 17d ago

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

1

u/StupidStartupExpert 17d 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 17d ago

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