| |
GeekInterview.com > Interview Questions > Database > Stored Procedures
| Print | |
Question: Difference between View and Stored Procedure
Answer: 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. |
| July 07, 2008 01:21:02 |
#4 |
| atdhdrolla |
Member Since: March 2007 Total Comments: 18 |
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.
|
| |
Back To Question | |
