title: Powershell foreach INSERT INTO SQL Server DB on multiple rows
body: <p>I am trying to insert 2 separate arrays into multiple records on 1 SQL Insert Command. I have done the foreach command but it will only accept 1 of the arrays. I have tried doing nested foreach statements but that just puts in way to many records. Below is the code I have so far. I am not posting my connection code to my DB but I ensure you that it connecting to the DB.</p>
  
  <pre><code>$array1 = @(1,2,3)
  $array2 = @(a,b,c)
  
  foreach ($file in $array1)
          { 
           $SqlQuery.Append("USE $SQLDBName;")
           $SqlQuery.Append("INSERT INTO tbl_File(Column1, Column2, Column3)")
           $SqlQuery.Append("VALUES('Dummy Data', '$file', '$array2');")
          }
  </code></pre>
  
  <p>What I am most confused about is how to make both arrays parse correctly into the DB. I hope I explained that correctly. Anything helps!</p>
  
  <p>Here is an example of what it will need to look like:</p>
  
  <pre><code>Column 1   |  Column 2   |  Column 3
  Dummy Data   User Input1   User Input1
  Dummy Data   User Input2   User Input2
  Dummy Data   User Input3   User Input3
  </code></pre>
  
  <p>This is what I want it to look like with Column 2 being the first array and column 3 being the second array. Column 1 will always be the same.</p>