What is the difference between views and stored procedures?
Can we have input parameters for views?
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 are different backups available in sql server?
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
How can sql injection be stopped? : sql server security
How to find the source of a table in sql server?
What is a result set object returned by mssql_query()?
What is report rendering ?
What is a data source file?
How to provide values to user defined function parameters?
Tell me what is use of except clause? How it differs from not in clause?
What is pessimistic concurrency?
What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration
Describe in brief sql server monitoring ways.
How many types of database relationship in sql server?
What is resource governor in sql server?
What is importing utility?