What is the difference between views and stored procedures?
Can we have input parameters for views?
Answer Posted / indhu karur
View:
V can define a select-query that retrieves
specific information from one or more tables
Sp:
A stored procedure can do much more: it can run
multiple sql-commands, has control-of-flow statements and
accepts
parameters
| Is This Answer Correct ? | 5 Yes | 4 No |
Post New Answer View All Answers
What is the difference between ddl,dml and dcl commands?
Can a database be shrunk with users active?
What is dynamic cursor in SQL SERVER?
What is trigger explain with program?
Explain trigger and trigger types?
what kind of lan types do you know? : Sql server database administration
What happens if null values are involved in bitwise operations?
Explain transaction server consistency?
What is equi join with example?
Which sql server is best?
What is shared lock?
Please differentiate between a local and a global temporary table?
What is sub query and its properties?
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
How does Report Builder support Analysis Services cubes?