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 sql injection and why is it a problem? : sql server security
What is primary key and example?
How to define output parameters in stored procedures?
What is a group function explain with an example?
How can I add Reporting Services reports to my application?
What the class forname () does?
How do you handle datasets larger than 50 gb?
How to connect of datebase with sql express.?
Do you know query execution plan?
What is an inner join?
What is the fillfactor concept in indexes?
Why use update_statistics command in sql server?
What is a matrix in ssrs?
What are the rules to use the rowguidcol property to define a globally unique identifier column?
How to use wildcard characters in like operations in ms sql server?