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)
-
When SQL Server executes a query it uses a query plan to determine how to access data and complete the query. SQL Server offers DBAs and d...
No comments:
Post a Comment