The intern learned a great lesson today...

No test environment??!

limit one would be a good thing to teach too

This is why I actually write the where clause first, then the rest of the update or delete query.

Wait for him to discover dropping tables. Such fun, backup much.

always start with: "begin tran"

"commit tran" after you are satisfied.

@DeepSpace same with emails. Writing the body first then the subject

Hopefully that is a one time mistake for the intern. Major lesson learned.

@matchacookie Yea he was local but still

I always write the select statement first, and when I'm happy I remove everything before where and replace with update / delete / whatevs. :)

how does that even happen???

rollback!!!!

always do it in a transaction. I learnt it the hard way.

A Post I read here once Said:

"I always start my update and delete querida with "LIMIT 1".

From there on, I always do that too, and if not necessary I remove after writing the full statement.

@freeridet I altered up the SSMS default templates to start with BEGIN TRAN and end with ROLLBACK. I only change it to COMMIT when I'm sure it's good. This has saved me many times from stupid mistakes, even long after I was no longer a beginner.