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
- 19526 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 transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
How to send a ssrs report from ssis?
What is scrollable cursor?
What are dml (data manipulation language) statements in ms sql server?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security
What is format parameter in ssrs?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
What happens when unicode strings concatenate with non-unicode strings?
Explain what is “asynchronous” communication in sql server service broker?
How to find the version of sql server? : sql server database administration
What is order of B+tree?
How to create prepared statements using odbc_prepare()?
How to find the service pack installed? : sql server database administration
What is bulkcopy in sql?
