title: Prevent accidental updates/deletes on any table
body: <p>It happened to me a couple of times to accidentally update all records of a production table.
  Lack of attention and whatnot...</p>
  
  <p>I've heard in MySQL to be a compile/run time switch to prevent such accidents.
  Like, if I would do a </p>
  
  <pre><code>UPDATE Table SET Field=0
  </code></pre>
  
  <p>this won't compile/run because of the missing WHERE clause. 
  And if you <em>really</em> wanted to update all, you could</p>
  
  <pre><code>UPDATE Table SET Field=0 WHERE 42=42
  </code></pre>
  
  <p>Any ideas for MS SQL? </p>
  
  <p>I found some answers online referring to a trigger. That would be a little costly I guess.
  And it would mean I must put the trigger on every necessary table. </p>