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
- 19262 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 to download and install the scaled-down database adventureworkslt?
How can you list all the table constraints in a database?
Differentiate between a local and a global temporary table?
What is 4nf in normalization form?
Define clusters?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
Is BCNF better than 2NF & 3NF? Why?
Explain microsoft sql server functions?
How to create a Master database in SQL server ?
What Are the Main Features of SQL Azure?
How to insert multiple rows with a subquery?
What is the difference between clustered and non-clustered indexes in ms sql server?
What is the difference between a local and a global temporary table?
How to truncate the log in sql server 2012? : sql server database administration
Explain full-text indexing?
