title: are stored procedures faster than functions or not
body: <p>I am using stored procedures at the moment but I have a lot of stuff like this:</p>
  
  <pre><code>if ... begin select 'success' return end
  if ... begin select 'notgood' return end
  if ... begin select 'someelse' return end
  </code></pre>
  
  <p>so I'm thinking that it would be a better idea to use functions instead, but is there any performance difference between functions and stored procedures ?</p>