Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between views and stored procedures?
Can we have input parameters for views?
- 6 Answers
- 19257 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
What are the new features are introduced in sql server 2012 reporting services?
What are the approximate numeric data types?
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
What are different types of roles provided by ssrs?
What is scd (slowly changing dimension)? : sql server analysis services, ssas
What are the requirements to use odbc connections in php scripts?
Where is localdb stored?
What are sql server functions?
What are the differences between user defined functions and stored procedures?
What is sql language?
Which is faster statement or preparedstatement?
How to find the list of fixed hard drive and free space on server?
Can an automatic recovery be initiated by a user?
How to convert a unicode strings to non-unicode strings?
What are different types of collation sensitivity?
