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
- 19261 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
Do you know what is a with(nolock)?
What options are there to delete rows on the publisher and not on the subscriber? : sql server replication
Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?
What are the differences between clustered and non-clustered index?
Define compound operators?
Can you please differentiate between a primary key and a unique key?
List few advantages of stored procedure.
Can we delete data from a view?
How can you find out how many rows returned in a cursor?
What's new in sql management studio for sql server? : sql server management studio
What is transact-sql ddl trigger?
Where the sql logs gets stored?
Can I run multiple instances of sql server 2000 at the same time on one computer?
What is the library index called?
