title: Query vs Stored procedure; difference between two approaches
body: <p>I am developing a web page for search. I have two options to build this page</p>
  
  <ol>
  <li><p>To build the query on page according to parameter enter by the user and send it to server.</p></li>
  <li><p>To send parameters to stored procedure and build query there and get it executed.</p></li>
  </ol>
  
  <p>I want to know that which approach I should adopt and why. </p>
  
  <p>I want to know the advantages or disadvantages of both approaches. </p>