| Author: Nikhil Gaur 24 Jun 2009 | Member Level: Diamond | Rating:  Points: 2 |
main difference is that in stored procedure we can write conditional quires but in quires we can't.
please rate the response if it helps.
Join this campus group
http://www.dotnetspider.com/sites/637/-ecb-aspdotnet.aspx
Thanks & Regards
NIks
My Software and Web Development Experience
|
| Author: Viji RAJKUMAR 24 Jun 2009 | Member Level: Diamond | Rating: Points: 2 |
Hi,
Stored Procedures are in compiled form. where as queries are not in compiled form.
Thus stored procedures can run fast.
The view is actually a logical view of the table.
It will not the affect the table.
To design views , we must carefully write the joins or any complex queries, otherwise view will run very slowly.
for example,
Create View MyView AS
SELECT * FROM Table1
It's like calling "Select * from table1" twice.
Regards
VIJI RAJKUMAR
Pls rate my Answer if it was supportive
http://vijirajkumar.blogspot.com
|
| Author: Miss Meetu Choudhary 24 Jun 2009 | Member Level: Diamond | Rating: Points: 2 |
Stored Procedures are pre-complied so they will run fast and also we can add cursor and other pl-sql statments to them over queries
and views they are just a mask for the actual table which alows you to habdle the visiblity of columns to the user.. but they work on actula table only such as insertion, deletion or updation of view data will affect the table..
Thanks and Regards
Miss Meetu Choudhary (Site Coordinator)
Go Green Save Green
My Profile on Google
|