title: Direct Sql or combine it in a procedure? which is more efficient
body: <p>in my recent subject ,I have to do some queries through dynamic SQL,But I'm curious about 
  the efficiency in different ways:<br/><br/>
  <strong>1)</strong>combine the sql sentences in my server and then send them to the database ,do the query<br/><br/>
  <strong>2)</strong>send my variables to database and combine them in a certain procedure and finally do the query<br/><br/>
  Hope someone can help<br/>
  BTW(I use .Net and Sqlserver)</p>