- View does not accepts parameters while SP takes parameters.
- View contain only one single query while SP contain several statements like conditional , loop etc.
- Can not perform modification in any table (DDL Statement) while SP can do this.
- View is nothing but an imaginary 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 difference is stored procedure exits in database where as view does not exits in database.