title: How to create a trigger to record changes for Insert,Update,Delete for multiple tables
body: <p>I have two tables in my Database.This can increase later on.I want to add another table Audit to track changes to the existing two tables.I want to track any change done to any of these table
  AUdit Table structure is <br>
  ID <br>
  Table_Name<br>
  Field_Name<br>
  Old_Value<br>
  New_Value<br>
  Modified_By<br>
  Date_of_Modification<br></p>
  
  <p>SO now I want to have one trigger for both tables which can be fired on an insert,update or delete to either of my tables.
  When this trigger is fired I want to insert values in Audit.When I'm updating I want the old value and new value.When inserting I want old value as nothing and new value as Inserted.When Deleting I want old value as the old existing value and new value as deleted.</p>