title: Generate XML from SQL Server using XML explicit and CDATA directive
body: <p>I need to generate the XML from the SQL Server 2008 R2 using 'For XML explicit' and CDATA directive. The output should be like following:-</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="utf-8" ?&gt;
  &lt;JOB&gt;
  &lt;AD&gt;
   &lt;ID&gt;&lt;![CDATA[ 451 ]]&gt;&lt;/ID&gt;
   &lt;TITLE&gt;&lt;![CDATA[ Receptionist ]]&gt;&lt;/TITLE&gt;
  &lt;/AD&gt;
  &lt;AD&gt;
   &lt;ID&gt;&lt;![CDATA[ 1025 ]]&gt;&lt;/ID&gt;
   &lt;TITLE&gt;&lt;![CDATA[ Secretary ]]&gt;&lt;/TITLE&gt;
  &lt;/AD&gt;
  &lt;/JOB&gt;
  </code></pre>
  
  <p>While, the schema of table is, </p>
  
  <pre><code>Table Name : AD
  Column1    : ID
  Column2    : TITLE
  </code></pre>
  
  <p>But, I am unable to achieve this and stuck somewhere.</p>
  
  <p>Many thanks.</p>