title: Stored Procedure to insert multiple rows from XML
body: <p>I am attempting to write a stored procedure to insert about 1 million rows into a table from a C# app. My app writes out the rows to a XML file and I want the app to then call a stored procedure with the XML file as a parameter. I've been looking around at other similar questions but I can't seem to get them to work and none of them seem to explain their answers. My XML only has 2 columns so I believe it should be fairly simple. I am using SQL Server 2005 and ASP.NET 2.0. My XML file looks like this:</p>
  
  <pre><code>&lt;?xml version="1.0" standalone="yes"?&gt;
  &lt;DocumentElement&gt;
    &lt;Test&gt;
      &lt;o_cus&gt;0&lt;/o_cus&gt;
      &lt;o_depot&gt;100001&lt;/o_depot&gt;
    &lt;/Test&gt;
  </code></pre>