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
- 19317 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 are different types of replication in sql server?
What are the five characteristics of good data?
What is subquery explain with example?
What does null mean?
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.
What is default constraint?
How can change procedure in sql server?
How can we migrate from SQL server to SQL Azure?
What is sql view?
While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?
Can truncate be rolled back?
Explain the truncate command?
What will be the maximum number of indexes per table?
What is instead of trigger sql server?
How to select some specific columns from a table in a query in ms sql server?
