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
- 19330 Views
- I also Faced
- E-Mail Answers
Answer Posted / grish varshney
views & stored procedure are basically different appraches.
both have their different purposes.
view is a virtual table. which have no data atall.which
difination stored in oracle system catalogue . whenever a
call is made every time the defination is scanned & a new
virtual table is made over the base table.
while stored procedure are the precompiled statements
which can accept arguments..
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
What is an expression in ms sql server?
What is the primary use of the model database?
What is spid in sql server profiler?
Does hive support indexing?
Where the sql logs gets stored? : sql server database administration
Explain indexing and what are the advantages of it?
What sql server means?
What are the types of lock supported by ?
How can we solve concurrency problems?
Can you edit the .rdl code associated with a linked report?
What is the default Port No on which SQL Server listens?
What are the reporting services components?
What is tempdb database? : SQL Server Architecture
Do you know what is lock escalation?
Does view occupy space?
