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
- 19492 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
What is the difference function and stored procedure?
Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
How do I start sql server?
What are the recovery models for a database?
Explain about SQL server 2005?
What is sparse columns of sql server 2008?
How to drop existing indexes in ms sql server?
What is difference between Datepart() and Datename() in SqlServer?
How to rebuild indexes with alter index ... Rebuild?
Can you leave a union at any time?
How to add more data to the testing table in ms sql server?
What is the cpu pressure?
How to access the deleted record of an event?
What is snapshot parameter in ssrs?
What is a result set object returned by mssql_query()?
