What is the difference between views and stored procedures?
Can we have input parameters for views?
- 6 Answers
- 18489 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 can we check the sql server version?
When does a workload on SQL Azure get throttled?
How to list all objects in a given schema?
How to provide login information for a new odbc dsn?
What is the contrast between sql and pl/sql?
What is sql service broker?
How you can add messages to the nt event log from within a stored procedure?
How do you open a cluster administrator?
What is onf in normalization form?
What is merge statement?
What are the different types of replication are there in sql server 2000?
Explain different types of locks in sql server.
Explain view in sql server?
What is the command dbcc checkdb used for?
What do you understand by physical_only option in dbcc checkdb?
