What is the difference between views and stored procedures?
Can we have input parameters for views?
- 6 Answers
- 18438 Views
- I also Faced
- E-Mail Answers
Answer Posted / chandana sriram
Well both of them aren't even compatible to compare and
tell the difference. They both belong to different paradigm
of database world. Anyways, here are the definitions I
would give you. A stored procedure is a set of sql
statements which can be called a subroutine to access
relational database systems. Its actually stored in a
daatabase. They are mainly used for faster access(Pre-
compilation of SQL statements) ,Simplification of data
management and for security.
A view as my friends have elucidated above is a virtual or
logical table that holds result set of a pre-defined query.
The data for these views are not stored in the database.
There are two types of view read only and updatable. You
can modify a read only view with an INSTEAD OF trigger.
Hope that makes sense :-)
| Is This Answer Correct ? | 20 Yes | 8 No |
Post New Answer View All Answers
How can you list all the table constraints in a database?
What is partition index in sql server?
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?
explain what is raid and what are different types of raid configurations? : Sql server database administration
How to create a user name in a database?
What are SSL and TSL protocols?
What is sql stored procedure?
What are Spatial data types in SQL Server 2008
when would you go for denormalization? : Sql server database administration
What is the index requirement in SQL Azure?
What is the difference between commit and rollback?
Explain an incremental backup?
What is GUID in sql server?
How do you Implement SSIS Packages in your Project?
List the ways in which dynamic sql can be executed?
