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
- 19496 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
what information is maintained within the msdb database? : Sql server administration
What are the different types of indexes?
How can you set the threshold at which sql server will generate keysets asynchronously?
What does it mean if @@cursor_row returns a negative number?
Can we linked SharePoint to a SQL database?
What are locks in sql?
How to implement service broker?
When to use Inner join & when to use subquery?
Where to find ntwdblib.dll version 2000.80.194.0?
What are the difference between primary key and unique key? : sql server database administration
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
What are the advantages of policy management?
What is difference between standardization and normalization?
What is read committed?
What is default constraint?
