title: SQL Trigger update another table
body: <p>I am newbie to triggers... can anybody help me with a trigger?</p>
  
  <p>I have Table:</p>
  
  <pre><code>Name | Number
  </code></pre>
  
  <p>I want to write a trigger when my table receives a query like</p>
  
  <pre><code>update MyTable 
  set Number = Number + 1 
  where Name = 'myname'
  </code></pre>
  
  <p>When this query is running, the trigger should update another table for example:</p>
  
  <pre><code>Update MyTable 2 
  set Column = 'something' 
  where Name = 'myname (above name)
  </code></pre>
  
  <p>Thank you very much !</p>