title: How to write UPDATE SQL with Table alias in SQL Server 2008?
body: <p>I have a very basic <code>UPDATE SQL</code> -</p>
  
  <pre><code>UPDATE HOLD_TABLE Q SET Q.TITLE = 'TEST' WHERE Q.ID = 101;
  </code></pre>
  
  <p>This query runs fine in <code>Oracle</code>, <code>Derby</code>, <code>MySQL</code> - but it <i>fails in SQL server 2008</i> 
  with following error: </p>
  
  <blockquote>
    <p>"Msg 102, Level 15, State 1, Line 1  Incorrect syntax near 'Q'."</p>
  </blockquote>
  
  <p>If I remove all occurrences of the alias, "Q" from SQL then it works.</p>
  
  <p>But I need to use the alias. </p>