Thursday 28 May 2015

Difference between Stored Procedures and Views

Difference between Stored Procedures and Views

Stored Procedures
Views
Does not accepts parameters
Accept parameters
Can be used as a building block in large query.
Can not be used as a building block in large query.
Can contain only one single Select query.
Can contain several statement like if, else, loop etc.
Can not perform modification to any table.
Can perform modification to one or several tables.
Can be used (sometimes) as the target for Insert, update, delete queries.
Can not be used as the target for Insert, update, delete queries.

No comments:

Post a Comment