Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between views and stored procedures?
Can we have input parameters for views?
- 6 Answers
- 19679 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
Characterize join and name diverse sorts of joins?
What is the use of keyword with encryption.
Tell me what is the stuff and how does it differ from the replace function?
How do I edit a stored procedure in sql server?
Explain temporary table vs table variable by using cursor alternative?
Define left outer join?
When we should use and scope of @@identity?
What is scheduled job and how to create it?
How to drop an existing stored procedure in ms sql server?
What is service broker?
Explain isolation levels that sql server supports?
How to download microsoft sql server 2005 express edition?
What are horizontal and vertical scaling?
Explain various data region available in ssrs with their use?
What are the underflow and overflow behaviors on float literals?
