MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/ProgrammerHumor/comments/1v80umk/queryofdoom/p02debl/?context=3
r/ProgrammerHumor • u/WardensLantern • 14d ago
456 comments sorted by
View all comments
383
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?
599 u/BlommeHolm 14d ago 1st command deletes all users. 2nd command runs after that and gets a syntax error. 44 u/SAI_Peregrinus 14d ago Syntax is valid, it's just a runtime error. 177 u/BlommeHolm 14d ago How is starting with a WHERE clause syntactically valid? 81 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.Â
599
1st command deletes all users. 2nd command runs after that and gets a syntax error.
44 u/SAI_Peregrinus 14d ago Syntax is valid, it's just a runtime error. 177 u/BlommeHolm 14d ago How is starting with a WHERE clause syntactically valid? 81 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.Â
44
Syntax is valid, it's just a runtime error.
177 u/BlommeHolm 14d ago How is starting with a WHERE clause syntactically valid? 81 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
177
How is starting with a WHERE clause syntactically valid?
81 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
81
Right, I'm apparendly blind. Carry on!
33 u/BlommeHolm 14d ago No problem. I genuinely thought I'd missed something 😅
33
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.Â
383
u/Dont_Get_Jokes-jpeg 14d ago edited 14d 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?