Friday 7 February 2014

What is difference between Views and stored procedure?






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.

No comments:

Post a Comment

First Database In Sql Server