title: Passing array to a SQL Server Stored Procedure
body: <p>How can I pass an array variable to a SQL Server stored procedure using C# and insert array values into a whole row?</p>
  
  <p>Thanks in advance.</p>
  
  <p>SQL Server table:</p>
  
  <pre><code>ID    | Product | Description
  -------------------------------
  8A3H  | Soda    | 600ml bottle
  </code></pre>
  
  <p>C# array:</p>
  
  <pre><code>string[] info = new string[] {"7J9P", "Soda", "2000ml bottle"};
  </code></pre>
  
  <p>SQL Server stored procedure:</p>
  
  <pre><code>ALTER PROC INSERT
      (@INFO_ARRAY ARRAY)
  AS
  BEGIN
      INSERT INTO Products VALUES (@INFO_ARRAY)
  END
  </code></pre>