The below mentioned points are key differences between View and SP .
S.No |
View |
Stored
Procedure |
1 |
View doesn't accepts parameters |
SP accept
parameters |
2 |
View Can
be used as a building block in large query. |
SP Cannot
be used as building block in large query. |
3 |
View can
contain only one single Select query. |
SP Can
contain several statement like if, else, loop etc . |
4 |
We cannot
perform modification to any table using Views. |
We can
perform modification to one or several tables. |
5 |
View can
be used (sometimes) as the target for Insert, update, delete queries. |
Cannot be used as the target for Insert, update, delete queries. |
6 View is a stored query. SP is reusable code component.
7. Select is used to execute EXEC is used to execute
No comments:
Post a Comment