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