27

DELETE FROM 'users' WHERE 1

Oops... 😧

Comments
  • 4
    I usually writes the WHERE first. And use top(x) to minimize the loss. 😊
  • 0
    @Drjonees completely agree with you! I think that when running an update/delete script without WHERE you should be given a warning. This could apply as well to massive row counts.
  • 0
    @Nakituki SSMS boost plugin gives you warnings for DELETE/TRUNCATE statements without WHERE clauses :)
Add Comment