title: Insert deleted rows in trigger
body: <p>I need to insert the deleted rows from table Table_A to Table_B which have the same structure<br>
  (something like recycle bin) but i don't have much experience in SQL SERVER Triggers  </p>
  
  <pre><code>CREATE TRIGGER dbo.Table_A_Delete_Instead_Of_Trigger
  ON dbo.Table_A
  INSTEAD OF DELETE
  AS
  BEGIN    
       INSERT INTO Table_B 
       SELECT T 
  
       DELETE T                  
  END
  </code></pre>
  
  <p>please spare my lake of experience. Thanks.</p>