What is the difference between a stored procedure and a view?

A view represents a query and is normally consumed like a table in SELECT statements. A stored procedure is an executable database module that can accept parameters, run multiple statements, perform modifications, use transactions, and return multiple result sets or output values.

Use a view when a reusable relational projection is needed. Use a stored procedure when the operation requires procedural behavior, parameters, multiple steps, controlled modifications, or an application-facing database command.