title: sql ORDER BY clause IN FOR XML
body: <pre><code>(SELECT t.seccolumnname 'td'
  FROM   DbName.TableName t
  WHERE  t.firstcolumname = 1
  ORDER  BY t.seccolumnname)
  FOR XML PATH('tr'), ROOT ('table')  
  </code></pre>
  
  <p>It gives me an error : Incorrect syntax near the keyword 'order'.</p>
  
  <p>Any ideas and suggestions</p>