title: Best way to implement a stored procedure with full text search
body: <p>I would like to run a search with MSSQL Full text engine where given the following user input:
  "Hollywood square"</p>
  
  <p>I want the results to have both Hollywood and square[s] in them.</p>
  
  <p>I can create a method on the web server (C#, ASP.NET) to dynamically produce a sql statement like this:</p>
  
  <pre><code>SELECT TITLE
  FROM MOVIES
  WHERE CONTAINS(TITLE,'"hollywood*"')
  AND CONTAINS(TITLE, '"square*"')
  </code></pre>
  
  <p>Easy enough.  HOWEVER, I would like this in a stored procedure for added speed benefit and security for adding parameters.</p>
  
  <p>Can I have my cake and eat it too?</p>