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
- 13553 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 is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
What is a synonym for manipulation?
What is difference between delete & truncate commands?
What are out-of-range errors with date and time literals?
What is right outer join in sql server joins?
What is bookmark link in ssrs?
How to make a remote connection in a database?
How to fetch the next row from a cursor with a "fetch" statement?
Explain use of expression builder.
what is isolation level at dead lock?
What is 2nf in normalization?
What are the rules to use the rowguidcol property to define a globally unique identifier column?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
How to query multiple tables jointly?
Do you know the policy based administration feature of sql server 2008?
