title: Updating Views vs. Triggers
body: <p>I am studying for a final exam, and came across this question:</p>
  
  <blockquote>
    <p>Explain why <em>updating views</em> is not recommended. Explain how triggers can be used to support view updates.</p>
  </blockquote>
  
  <p>I have looked on the web, and read a couple chapters from the book to no avail.</p>
  
  <p>I have seen points made to where views can help make life easier, but none arguing against them.</p>
  
  <p>Is this a possible answer?</p>
  
  <blockquote>
    <p>One could use the <code>INSTEAD OF</code> clause in a <code>TRIGGER</code> statement in order to circumvent the updating of a table. This would allow for the update of multiple tables that could be represented by one view.</p>
  </blockquote>
  
  <p>So, my questions are:</p>
  
  <p>1.) Why are updating views not recommended?</p>
  
  <p>2.) How can triggers be used as a solution to the problem?</p>