title: Replace After Delete trigger by Instead of trigger
body: <p>I'm trying to ignore the deletion of employees that have a salary higher than 5000. I'm using an <code>after delete</code> trigger on the <code>Employee</code> table. If the employee deleted has a salary higher 5000, it reinserts the row into the <code>Employee</code> table.</p>
  
  <pre><code>CREATE TRIGGER T1 ON Employee 
  AFTER DELETE
  AS
      INSERT INTO Employee
          SELECT * 
          FROM DELETED D
          WHERE D.salary &gt; 5000
  </code></pre>
  
  <p>Is there any way of doing this without reinserting the row? How can I use  <code>INSTEAD OF</code> trigger in place of <code>AFTER DELETE</code>?</p>