title: Remove xmlns="" name space declaration when using FOR XML EXPLICIT
body: <p>I'm generating an XML document using <code>FOR XML EXPLICIT</code>:</p>
  
  <pre class="lang-sql prettyprint-override"><code>declare @MyTable table (value xml);
  
  insert into @MyTable values
   ('&lt;foo bar="data1"&gt;content1&lt;/foo&gt;')
  ,('&lt;foo bar="data2"&gt;content2&lt;/foo&gt;')
  ,('&lt;foo bar="data3"&gt;content3&lt;/foo&gt;');
  
  select 1 as Tag, null as Parent
      , value as [x!1!!xml]
  from @MyTable
  for xml explicit;
  </code></pre>
  
  <p>And get such a response:</p>
  
  <pre class="lang-xml prettyprint-override"><code>&lt;x&gt;
    &lt;foo bar="data1" xmlns=""&gt;content1&lt;/foo&gt;
  &lt;/x&gt;
  &lt;x&gt;
    &lt;foo bar="data2" xmlns=""&gt;content2&lt;/foo&gt;
  &lt;/x&gt;
  &lt;x&gt;
    &lt;foo bar="data3" xmlns=""&gt;content3&lt;/foo&gt;
  &lt;/x&gt;
  </code></pre>
  
  <p>The problem is that I don't need the <code>xmlns</code> attribute.</p>
  
  <p>I found a solution, but it seems to be a kludge.</p>
  
  <pre class="lang-sql prettyprint-override"><code>select 1 as Tag, null as Parent
      , cast (value as varchar(200)) as [x!1!!xml]
  from @MyTable
  for xml explicit;
  </code></pre>
  
  <p>Is there a more elegant way to solve the problem?</p>
  
  <p>Do not offer using <code>FOR XML PATH/RAW/AUTO</code>.</p>
  
  <p><code>EXPLICIT</code> mode is must.</p>