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
- 19535 Views
- I also Faced
- E-Mail Answers
Answer Posted / ashutosh jha
both can never be compares, as both have totally different
approached,
Well a view is a output of a query ,and makes a virtual
image of the table,and the input parameters are not accepted.
sp is a group of sql statements that are pre-executed and it
accepts the parameters.it reduces network traffic, gives
faster performance, etc.
| Is This Answer Correct ? | 42 Yes | 2 No |
Post New Answer View All Answers
How many joins in sql server?
What are Spatial data types in SQL Server 2008
What are truncate options available in sql server? : sql server database administration
What is 'write-ahead log' in sql server 2000 ?
Explain how does the report manager work in ssrs?
What are different types of table joins?
What are the difficulties faced in cube development? : sql server analysis services, ssas
Explain activity monitors
Why olap is used?
How does Report Builder support Analysis Services cubes?
Difference Between ORDER BY Clause and GROUP BY Clause in SQL?
Does any body please help me what question's have asked for SSRS in the interview?
What is bcnf normalization form?
What is inner join? Explain with an example?
What is difference between group by and having?
