title: Write and save select statement data in xml
body: <p>Can anyone help me in SQL  if it's possible to write xml file of any select statement data and save it in local drive .</p>
  
  <p>Case :_</p>
  
  <pre><code>Select * from tableName for xml auto
  </code></pre>
  
  <p>This generates the xml file but I want to save it in the local drive ie.( the C drive or the D drive)</p>
  
  <p>Will truly appreciate.  :)</p>