title: Insert values from a list in a single SQL statement
body: <p>I have a list with values in it. I want to insert these values in a SQL table using a single <code>INSERT</code> statement.</p>
  
  <p>Example: Say, there is a list with names (the size of the list is not constant). There is a <code>STUDENTS</code> table with <code>NAME</code> column. I want to insert in the <code>STUDENTS</code> table the names from the list using a single <code>INSERT</code> statement.</p>
  
  <p>Right now I loop through the list and insert the value in the table. That means, the number of insert statements is equal to the length of the list.</p>
  
  <pre><code>List&lt;String&gt; Name;
  foreach (String s in Name)
  {
    INSERT INTO STUDENTS (NAME) VALUES (s)
  }
  </code></pre>
  
  <p>Is there a way I can accomplish this in a single SQL <code>INSERT</code> statement? Any help is much appreciated.</p>