difference between stored procedure and view's

Question

difference between stored procedure and view's?

Puneet Kankar · Answer

Stored ProcedureStored Procedure can have multiple select statement Stored Procedure can have parameters Stored Procedure exists in database Stored procedure return predefined result. View View can have only one select statement View does not have any parameter View are virtual and does not exists in database Views can return different result based on where condition.

Ravi Kiran Chanduri · Answer

Difference between SP and VW http://www.dotnettricks.com/learn/sqlserver/difference-between-stored-procedure-and-function-in-sql-server When to use SP and when to use VW https://ask.sqlservercentral.com/questions/4788/when-to-use-view-and-stored-procedures-.html