Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Stored Procedure , Function
and Package,
1. how many blocks in Package and what are they.
- 5 Answers
- 13110 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / bunty_18
1>Stored procedure is pre-executed block of code whereas
function is not.
2>Stored procedure may return zero,one or more than one value
whereas function always return one and only one value..
3>We can use try catch block in stored procedure whereas
function doesn't support try catch block...
4>We can't use stored procedure in select statement whereas we
use function in select statement..
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
What are the different methods available under sqlcommand class to access the data?
What is model database in sql server?
What is advantage data architect?
How do you create type- insensitive operator?
What is cross join in sql server joins?
Write an sql query to find first weekday of the month?
Can an automatic recovery be initiated by a user?
What is subquery in sql?
Where is my database stored on the hard disk in ms sql server?
What are system databases into sql server (2005/2008)?
What is a cache in ssrs?
what type of index will get created after executing the above statement? : Sql server database administration
Explain what is the purpose of sql profiler in sql server?
Tell me when is the update_statistics command used?
Does dbcc checkdb requires db to be in single_user mode? : sql server database administration
