Views | Stored Procedures |
No option to return customized result set | Can be customized to handle many requirements in single SP |
Views cannot be parameterized. | Can be parameterized. can return multiple result sets. Can return different result based on parameters |
no control on the way end user manipulate Views | have control over final data |
Bad usage* of view may kill production server performance(*non sargable conditions in view) | more control over the stored procedure usage |
Internal data processing not possible | Data can be processed using programming constructs |
Views can be used in SELECT commands and can be joined with other views or tables | Stored procedures usually won’t be part of SELECT statement. |
Friday, 7 February 2014
What is difference between Views and stored procedure?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment