title: Bulk insert with many files inside folder
body: <p>I want to read xml files with sql server. I show below how I do it.</p>
  
  <pre><code>DECLARE @testxml TABLE (IntCol int, XmlCol xml);
      INSERT INTO @testxml(XmlCol)
      SELECT * FROM OPENROWSET(
         BULK 'C:\XMLs\32056963_0001515351.xml',
         SINGLE_BLOB) AS x;
  
  SELECT * FROM @testxml
  </code></pre>
  
  <p>All is ok. But I need to read many files inside a folder, so I'm using:</p>
  
  <pre><code>EXEC master.sys.xp_dirtree 'C:\XMLs\',0,1;
  </code></pre>
  
  <p>But how can I doing a dynamic bulk insert in order to insert all xml files in the folder to @testxml?</p>