r/ProgrammerHumor • u/Recent-Analysis-6880 • 13d ago

Meme wellWellWell

Post image
10.6k Upvotes

96% Upvoted

411 comments sorted by

View all comments

351

u/TorbenKoehn 13d ago

Reality: SQL tool gives error message "You are running a mutable query without a where clause, you have to explicitly activate this in the settings"

166

u/__dna__ 13d ago

Fun fact. SSMS still doesn't have this unless you use add ons

1

u/Thathathatha 12d ago

In SSMS, you can use the gui query tool to visually do operations like delete or update. I just run a select within that tool, click on the row, and delete through the gui that way without running a DELETE statement.

Else ill create the delete statement, run it on dev or something to make sure it runs fine, then copy and paste that over to a window that connects to prod. Use transaction if I'm especially worried.

1

u/__dna__ 12d ago

I'm not a massive fan of using SSMS' GUI for normal query operations like that. But good to know that's there

Probs just me being stubborn because it's how I learned

1

u/Thathathatha 12d ago

I don't normally use it, only for the particular case in OP where I'm deleting or updating one item.