- Stored Procedure can have multiple select statement
- Stored Procedure can have parameters
- Stored Procedure exists in database
- Stored procedure return predefined result
- View can have only one select statement
- View does not have any parameter
- View are virtual and does not exists in database
- Views can return different result based on where condition.