title: How do you keep HTML tags when querying a xml using sql?
body: <p>I want to keep html tags in my sql query when i write a query to generate xml tags.
  For example:</p>
  
  <pre><code>select '&lt;p&gt; this is a code&lt;/p&gt;' as code
  from table name
  for xml path (''), type
  </code></pre>
  
  <p>outputs:</p>
  
  <pre><code>&lt;code&gt;&amp;ltp&amp;gt; this is a code &amp;lt/p&amp;gt; &lt;code&gt;
  </code></pre>
  
  <p>what it should output:</p>
  
  <pre><code>&lt;code&gt;&lt;p&gt; this is a code &lt;/p&gt;&lt;code&gt;
  </code></pre>
  
  <p>How do I solve this? Thanks!</p>