Difference between View and Stored Procedure

S.No	View	Stored Procedure
1	Does not accepts parameters	Accept parameters
2	Can be used as a building block in large query.	Cannot be used as a building block in large query.
3	Can contain only one single Select query.	Can contain several statement like if, else, loop etc.
4	Cannot perform modification to any table.	Can perform modification to one or several tables.
5	Can be used (sometimes) as the target for Insert, update, delete queries.	Cannot be used as the target for Insert, update, delete queries.