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
- 19332 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
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration
Benefits of Stored Procedures?
Explain what are various ways to enhance the ssrs report?
What is nolock hint in sql server 2008
What is the difference between varchar and nvarchar datatypes?
What are secondary xml indexes?
What are the advantages of user defined function?
Why use view instead of a table?
What are various limitations of the views?
Do you know the isolation level that sql server support?
How can I create a report based on a query? : sql server management studio
What is difference between drop truncate and delete?
Write a code to select distinct records without using the DISTINCT keyword.
Write a query to find 5th highest amount paid from the customer table.
Explain the difference between delete,drop and truncate in SQL Server?
