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
- 19687 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 you check the version of sql server?
What happens when transaction log is full?
What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration
How to rebuild all indexes on a single table?
What is the use of tempdb? What values does it hold?
What is difference between line feed ( ) and carriage return ( )?
How to turn off warning messages during php execution?
What is sparse columns of sql server 2008?
What is Lock table in SQL?
How do I create an extended event in sql server?
Why de-normalization required?
How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?
What is the default fill factor value?
What is the default value of an integer data type in sql server 2005?
What are the difference between primary keys and foreign keys?
