title: When to use function and when to use stored procedure in SQL Server
body: <p>When to use function and when to use stored procedure in SQL Server? </p>
  
  <p>I would like to know about people's thoughts and experience on it. Also, would like to know when to use the views. I am not looking for the definition of these db objects. A practical scenario discussion would be good</p>