What is the difference between views and stored procedures?
Can we have input parameters for views?
Answer Posted / mukesh
All above answers are exactly correct.
In a different approach my answer is,
View is for Static approach. We cannot create a view with dynamic values.
SP is for Dynamic/Run-time values.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is star, snowflake and star flake schema? : sql server analysis services, ssas
How to divide query output into multiple groups with the group by clause in ms sql server?
Why do we use functions?
What stored by the msdb? : sql server database administration
What is bit data type? What's the information that can be stored inside a bit column?
What is the difference between left and right outer join?
What is the purpose of the model database?
What Is Rdbms?
What is model database? : SQL Server Architecture
Differentiate between truncate vs delete in mssql?
Can we delete data from a view?
What is data compression?
When would you use the stored procedures or functions?
What is the difference between Triggers and Stored Procedure?
What are the differences between triggers and stored procedures?