What is the difference between views and stored procedures?
Can we have input parameters for views?

Answers were Sorted based on User's Feedback



What is the difference between views and stored procedures? Can we have input parameters for views?..

Answer / ashutosh jha

both can never be compares, as both have totally different
approached,

Well a view is a output of a query ,and makes a virtual
image of the table,and the input parameters are not accepted.

sp is a group of sql statements that are pre-executed and it
accepts the parameters.it reduces network traffic, gives
faster performance, etc.

Is This Answer Correct ?    42 Yes 2 No

What is the difference between views and stored procedures? Can we have input parameters for views?..

Answer / 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

What is the difference between views and stored procedures? Can we have input parameters for views?..

Answer / grish varshney

views & stored procedure are basically different appraches.
both have their different purposes.
view is a virtual table. which have no data atall.which
difination stored in oracle system catalogue . whenever a
call is made every time the defination is scanned & a new
virtual table is made over the base table.
while stored procedure are the precompiled statements
which can accept arguments..

Is This Answer Correct ?    6 Yes 3 No

What is the difference between views and stored procedures? Can we have input parameters for views?..

Answer / sandeep

At times, the database administrator might want to restric access of data to different users. They
might want some user to be able to access to all columns of a table wheras other users to be able to access only selected columns.The sql server allows you to create views to restric user access to the data.Views also help in simplifying query execute when the query involves retrieving data from maltiple tables by applying joins.

Is This Answer Correct ?    3 Yes 0 No

What is the difference between views and stored procedures? Can we have input parameters for views?..

Answer / indhu karur

View:
V can define a select-query that retrieves
specific information from one or more tables

Sp:
A stored procedure can do much more: it can run
multiple sql-commands, has control-of-flow statements and
accepts
parameters

Is This Answer Correct ?    5 Yes 4 No

What is the difference between views and stored procedures? Can we have input parameters for views?..

Answer / mukesh

All above answers are exactly correct.
In a different approach my answer is,
View is for Static approach. We cannot create a view with dynamic values.
SP is for Dynamic/Run-time values.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

write sql program to get the detail of student in a class?

2 Answers  


What do you understand by sql server agent?

0 Answers  


How do we rollback the table data in SQL Server

3 Answers  


Which are the third-party tools used in sql server and why would you use them?

0 Answers  


What are the diifferences between the ms sql server vs mysql?

0 Answers  






What are sql server procedures?

0 Answers  


Define the term DML, DDL and DTL?

1 Answers  


Do you have any idea about the tcl commands?

0 Answers  


Which is the latest version of sql server and when it is released?

0 Answers  


UPDATE statement can on a single table or on the multiple table?

7 Answers   iGate, TCS,


What is indexing and its types?

0 Answers  


What is a self join in sql server?

0 Answers  


Categories