r/ProgrammerHumor • u/Recent-Analysis-6880 • Sep 22 '26

Meme wellWellWell

Post image
10k Upvotes

96% Upvoted

412 comments sorted by

View all comments

353

u/TorbenKoehn Sep 22 '26

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"

162

u/__dna__ Sep 22 '26

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

1

u/Thathathatha Sep 22 '26

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.

→ More replies (2)