What is the difference between views and stored procedures?
Can we have input parameters for views?
- 6 Answers
- 17650 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 types of triggers in sql server?
mention different types of relationships in the dbms?
What is the use of group by clause?
How does recursive cte works in sql server?
Explain having clause?
Explain system rowset functions?
What is the contrast between sql and pl/sql?
What does asynchronous call backs means?
What is sqlservr.exe - process - sql server (sqlex?press)?
How to insert data into an existing table?
What is the significance of master, tempdb and model databases?
Can we write ddl in trigger?
how to create “alternate row colour”?
Can a rule be bound to any column of any data type?
How to read data in a table with "select" statements?
