title: Which one is best View or Stored procedure in sql server for data access purpose
body: <p>I often use stored procedure for data access purpose but don't know which one is best view or SP. </p>
  
  <p>Stored procedure and views are both compiled and execution plan is saved in database. So please tell me which one is best for data access purpose and why best list down the reason please. </p>
  
  <p>I search google to know which one is best but got no expected answer.</p>