Stored Procedures - Difference between View and Stored Procedure

GeekInterview.com > Interview Questions > Database > Stored Procedures

Go To First | Previous Question |

Stored Procedures | Question 12 of 12

Difference between View and Stored Procedure

What is the difference between View and Stored Procedure? Can views accept input parameters as stored procedure? If yes,how could I do that? I am new to database and working on MS SQL,if someone could suggest me good reference websites then that would be great.

Total Answers and Comments: 4

Last Update: July 16, 2008 Asked by: preetiv

Sponsored Links

Best Rated Answer

—

Submitted by: atdhdrolla

View - A View in simple terms is a subset of a table. It can be used to retrieve data from the tables, Insert, Update or Delete from the tables. The Results of using View are not permanently stored in the database.

Stored Procedure - A stored procedure is a group of SQL statements which can be stored into the database and can be shared over the netwrok with different users.

Above answer was rated as good by the following members:
sagarapardeshi, ibrarx, himanshu D silva, ZPinku, kwartz, rajneeshchaudhary, infoeweb, sandeep549

June 19, 2008 02:44:47

naveenchowki

Member Since: June 2008 Contribution: 2

RE: Difference between View and Stored Procedure

view is nothing but an imagenary table .it contains data at run time only not created in the database where as stored procedure can be used to store business logic..it is created at database level.
main differece is stored procedure exits in database where as view doesnot exits in database.

Is this answer useful? Yes | No

2 0

Overall Rating: +2

June 19, 2008 02:46:07

naveenchowki

Member Since: June 2008 Contribution: 2

RE: Difference between View and Stored Procedure

i think view doesn't accepts any parameters.

Is this answer useful? Yes | No

July 11, 2008 02:59:22

ashwin890

Member Since: July 2008 Contribution: 2

RE: Difference between View and Stored Procedure

view is virtual table With view you can restirct the user to see what is required for him and stored procedure is pre compiled transact sql statments which is compiled once stored on the server

Is this answer useful? Yes | No

July 16, 2008 01:21:02

atdhdrolla

Member Since: March 2007 Contribution: 19

RE: Difference between View and Stored Procedure

View - A View in simple terms is a subset of a table. It can be used to retrieve data from the tables Insert Update or Delete from the tables. The Results of using View are not permanently stored in the database.

Stored Procedure - A stored procedure is a group of SQL statements which can be stored into the database and can be shared over the netwrok with different users.

Is this answer useful? Yes | No

7 2

Overall Rating: +5

Go To Top

User Name		Remember Me?
Password

Question Bank