title: Single Trigger for multiple events
body: <p>I have two tables in my SQL Server database say <code>Trainer(TrainerID, Username, Password, email, .... )</code> and <code>TrainerPassword (ID, TrainerID, Password, CreationDate)</code>. TrainerPassword(TrainerID) refers to Trainer(TrainerID). Baseline of task is to track password changes of the trainer. I'm using Trigger on Trainer table.</p>
  
  <p>Now the issue raises in how to fire the trigger for the events </p>
  
  <ul>
  <li>AFTER INSERT - Adding and entry to TrainerPassword after an updation/insertion happens in Trainer table.</li>
  <li>BEFORE DELETE - Deletion of record in Trainer table should delete references in TrainerPassword </li>
  </ul>
  
  <p>Can both of these events implemented in  single trigger...?</p>