title: Create stored procedure with CONTAINS in SQL Server 2008
body: <p>I want to create a stored procedure to do some combined keyword search using CONTAINS,something like below:</p>
  
  <pre><code>SELECT theContent
  FROM FtsTest
  WHERE CONTAINS
     (theContent, 
     ' FORMSOF (INFLECTIONAL, keyword1) AND FORMSOF (INFLECTIONAL, keyword2)');
  </code></pre>
  
  <p>and he number of keywords may vary, so I tried to pass the whole 'FORMSOF... AND FORMSOF.....'clause as a parameter,declaring the parameter as nvarchar(max),but it won't let me do it,saying The argument type "nvarchar(max)" is invalid for argument 2 of "CONTAINS".</p>
  
  <p>So, is there any way to make it work with the sp?
  Thanks!</p>