title: SQL Server Procedure Parameter List
body: <p>I'm using .Net SqlParameter, but I'd like send to my procedure a list of terms to search. For example</p>
  
  <p>My list would be like that:</p>
  
  <pre><code> Title   |  Value
  'Women'  | 'Chain'
  'Little' | 'Boy'
  </code></pre>
  
  <p>I need for each terms include a row like this:</p>
  
  <pre><code>AND (field.Name = @title AND contains(fv.Value, @value))
  AND (field.Name = 'Women' AND contains(fv.Value, '"Chain"'))
  AND (field.Name = 'Little' AND contains(fv.Value, '"Boy"'))
  </code></pre>
  
  <p>How can I perform this?</p>