title: How to get value of deleted test in trigger?
body: <p>I need to put a trigger on Delete on Table1. On delete of record from Table1, I need to update Table2 in trigger, but i need the value of deleted record in the trigger.
  Example:-</p>
  
  <pre><code>IF OBJECT_ID ('UpdateLog','TR') IS NOT NULL
      DROP TRIGGER UpdateLog;
  GO
  CREATE TRIGGER UpdateLog
  ON Table_1
  AFTER DELETE 
  AS
     UPDATE Table_2
      SET Date1 = getdate()
      WHERE (UID from deleted record from Table1)
  GO
  </code></pre>
  
  <p>So I need value of deleted record from table1 to update the table2. How?</p>