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
Explain about integration services of Microsoft SQL server?
How would you add a section to a table?
What is hot add cpu in sql server 2008?
What do you mean by data manipulation language?
What is the server name for sql management studio?
Why we should not use triggers?
How do you use a subquery to find records that exist in one table and do not exist in another?
How to create new tables with "select ... Into" statements in ms sql server?
What is provisioning, billing and metering, and connection routing concepts in the service layer?
what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration
What is the difference between Clustered and Non-Clustered Index?
How do you make a trace?
what are the types of indexes? : Sql server database administration
Find columns used in stored procedure?
What are the different Topologies in which Replication can be configured?