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.
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.
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
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.
