What is the difference between views and stored procedures?
Can we have input parameters for views?
- 6 Answers
- 18436 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
tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
when you create a database how is it stored? : Sql server database administration
Why is the need for data conversion transformations?
Does group by or order by come first?
What is dbcc? Give few examples.
Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?
What is the default Port No on which SQL Server listens?
what is raid and what are different types of raid configurations? : Sql server database administration
Define master database?
do views contain data ?
What is difference between Datepart() and Datename() in SqlServer?
What are sql server procedures?
What are the difference between clustered and a non-clustered index?
What are the steps you should follow to start sql server in single-user mode?
How to create a large table with random data for index testing in ms sql server?
