What is the difference between views and stored procedures?
Can we have input parameters for views?
- 6 Answers
- 17719 Views
- I also Faced
- E-Mail Answers
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
A trigger can reference objects outside the current database? State true or false.
How can we call UDF(User Define Function) using C# code in ASP.net ?
What is checkpoint in sql server?
What is the difference between clustered and non-clustered indexes in ms sql server?
What is #table in sql server?
How to create an index on an existing table in ms sql server?
Explain what role entity and relationship play in an ER diagram.
What is the process of normalization?
How to store and query spatial data?
How do I find sql server instance name?
What are commit and rollback in sql?
How to enter binary string literals in ms sql server?
Tell me what are cursors and when they are useful?
How do I determine how many instances of sql server are installed on a computer?
What is the dbcc command and why is it used?
