title: Trigger update another table after deletion
body: <p>SQL Server 2008: I'm trying to create a trigger that will change the value of a column in <code>Student</code>, when a column in <code>Enroll</code> is deleted.</p>
  
  <p>I've been trying to follow the documentation, but it's going way over my head.  </p>
  
  <p>Thank you.</p>
  
  <pre><code>CREATE TRIGGER Student_Drops
  ON Enroll
  AFTER DELETE
  AS
      SET NOCOUNT ON;
  
      UPDATE Student
      SET Student.Credits = Student.Credits - 3
      WHERE Student.stuID = deleted.stuID
  </code></pre>