title: Insert single xml element into sql like string manipulation
body: <p>Hi I have a XML file like this</p>
  
  <pre><code>&lt;pictures&gt;
  &lt;mainimg&gt;
  &lt;link&gt;http://s.freshnewtracks.com/wp-content/uploads/2012/07/dr_dre_20011.jpeg&lt;/link&gt;
  &lt;/mainimg&gt;
  &lt;img&gt;
  &lt;title&gt;back&lt;/title&gt;
  &lt;link&gt;http://s.freshnewtracks.com/wp-content/uploads/2012/07/dr_dre_20011.jpeg&lt;/link&gt;
  &lt;/img&gt;
  &lt;web&gt;&lt;/web&gt;
  &lt;twitter&gt;&lt;/twitter&gt;
  &lt;facebook&gt;&lt;/facebook&gt;
  &lt;myspace&gt;&lt;/myspace&gt;
  &lt;about&gt;&lt;/about&gt;
  &lt;/pictures&gt;
  </code></pre>
  
  <p>I need to INSERT this XML into a SQL Datatable without using XML file on disk. I have seen other examples where it is done by using a xml file on disk. I want to do this with typed/string XML without saving to disk/BULK <a href="https://www.google.co.uk/url?sa=t&amp;rct=j&amp;q=&amp;esrc=s&amp;source=web&amp;cd=1&amp;cad=rja&amp;ved=0CDEQFjAA&amp;url=http://blogs.msdn.com/b/simonince/archive/2009/04/24/flattening-xml-data-in-sql-server.aspx&amp;ei=i0mbUffAB_SY0AWTtoDIAg&amp;usg=AFQjCNHIycw6hRuG6a80Ur_ekojWxnKefQ&amp;sig2=3vTNOLGdYVB_83AXrEUKVw&amp;bvm=bv.46751780,d.d2k" rel="nofollow">Link</a> For eg something like</p>
  
  <pre><code>INSERT INTO Table (XMLColumn)
  VALUES (XML LIKE STRING)
  </code></pre>
  
  <p>Is this possible? Can I have some controls over the elements of XML file for each row?</p>