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
- 19493 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
Explain “row_number()” in sql server with an example?
How can a database be repaired?
Which table keeps information about stored procedures?
How to insert data with null values?
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
What sql server means?
What are different types of raid levels?
Explain datetimeoffset data type in sal server 2008?
What are views used for?
What is the difference between a local and a global temporary table?
How do I install sql server?
what kind of lan types do you know? : Sql server database administration
What are scalar functions in sql?
What is a collation in ms sql server?
Is candidate a key?
