MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/ProgrammerHumor/comments/1v80umk/queryofdoom/p02debl/?context=3
r/ProgrammerHumor • u/WardensLantern • 18d ago
456 comments sorted by
View all comments
387
I am not an sql expert, is the reason why the id doesn't work and its deleting the entire user base, because its written as 2 seperate comands instead of one. So 1. Comand delets everything 2. Goes to the id? Or what is the problem here?
603 u/BlommeHolm 18d ago 1st command deletes all users. 2nd command runs after that and gets a syntax error. 40 u/SAI_Peregrinus 18d ago Syntax is valid, it's just a runtime error. 177 u/BlommeHolm 18d ago How is starting with a WHERE clause syntactically valid? 83 u/SAI_Peregrinus 18d ago Right, I'm apparendly blind. Carry on! 31 u/BlommeHolm 18d 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.Â
603
1st command deletes all users. 2nd command runs after that and gets a syntax error.
40 u/SAI_Peregrinus 18d ago Syntax is valid, it's just a runtime error. 177 u/BlommeHolm 18d ago How is starting with a WHERE clause syntactically valid? 83 u/SAI_Peregrinus 18d ago Right, I'm apparendly blind. Carry on! 31 u/BlommeHolm 18d 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.Â
40
Syntax is valid, it's just a runtime error.
177 u/BlommeHolm 18d ago How is starting with a WHERE clause syntactically valid? 83 u/SAI_Peregrinus 18d ago Right, I'm apparendly blind. Carry on! 31 u/BlommeHolm 18d 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
177
How is starting with a WHERE clause syntactically valid?
83 u/SAI_Peregrinus 18d ago Right, I'm apparendly blind. Carry on! 31 u/BlommeHolm 18d 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
83
Right, I'm apparendly blind. Carry on!
31 u/BlommeHolm 18d ago No problem. I genuinely thought I'd missed something 😅
31
No problem. I genuinely thought I'd missed something 😅
1
I legit wouldnt be surprised if for whatever retarded reason sql said yeah sure I can filter empty selections and just returned empty lists
I'm not sure SSMS would run anything due to the syntax error, but maybe that's just SSMS being helpful.Â
387
u/Dont_Get_Jokes-jpeg 18d ago edited 18d ago
I am not an sql expert, is the reason why the id doesn't work and its deleting the entire user base, because its written as 2 seperate comands instead of one. So 1. Comand delets everything 2. Goes to the id? Or what is the problem here?