title: Update Top 1 record in table sql server
body: <p>My Query </p>
  
  <pre><code>UPDATE TOP (1) TX_Master_PCBA  
  SET TIMESTAMP2 = '2013-12-12 15:40:31.593'
  WHERE SERIAL_NO IN ('0500030309') 
  ORDER BY TIMESTAMP2 DESC 
  </code></pre>
  
  <p>with <code>serial_No</code> Column in <code>TX_Master_PCBA</code> table i have 10 records but i want to update the latest <code>TIMESTAMP2</code> to current datetime.</p>
  
  <p>the above query is throwing error : </p>
  
  <blockquote>
    <p>Incorrect syntax near the keyword 'TOP'.</p>
  </blockquote>