title: Export XML data type column with Microsoft SQL Server Management Studio
body: <p>I have a table with 2 columns. The column response is an XML data type column (I am able to click on it an open the XML document). I would like to have a code that would export each row of the column response into an XML document saved on my desktop. Path = <code>C:\Users\SAM\Desktop\Folder</code>.</p>
  
  <p>So I would have an XML document for each row.</p>
  
  <p>Output:</p>
  
  <pre><code> SELECT * FROM Table
  
   Data           Response
  20130101    &lt;Getresponsequ…
  20130102    &lt;Getresponsequ…
  20130103    &lt;Getresponsequ…
  20130104    &lt;Getresponsequ…
  20130105    &lt;Getresponsequ…
  20130106    &lt;Getresponsequ…
  </code></pre>
  
  <p>I am using Microsoft SQL Server Management Studio.</p>
  
  <p>Thanks in advance!</p>