title: SQL Server trigger execution
body: <p>Say I have an UPDATE trigger on <code>tableA</code> that inserts a new record into <code>tableB</code>. </p>
  
  <pre><code>CREATE TRIGGER insertIntoTableB
  ON tableA
  FOR UPDATE 
  AS
     INSERT INTO tableB (...) VALUES (...)  
  GO
  </code></pre>
  
  <p>I then run these statements sequentially. Will the second UPDATE statement (UPDATE <code>tableB</code>) work OK? (i.e. wait for the trigger on table A to fully execute)</p>
  
  <pre><code>UPDATE tableA
  SET ...
  WHERE key = 'some key'
  
  UPDATE tableB
  SET ...
  WHERE key = 'newly inserted key from trigger'
  </code></pre>