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.
there is only one difference between views and stored procedure. 1. we can put query on View but we cannot put query on Stored Procedure.