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
- 13353 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 tabulation?
How to create and drop temp table in sql server?
Where actually sql azure database is hosted?
Where the sql logs gets stored?
Why I have to use stored procedures?
What is cube dimension? : sql server analysis services, ssas
System requirements for sql server 2005 express edition?
How to delete multiple rows with one delete statement in ms sql server?
What are the extra roles available in msdb? : sql server security
What are a scheduled jobs or what is a scheduled tasks?
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
How many replicas are maintained for each SQL Azure database?
What are different types of replication in sql server?
Describe in brief databases and sql server databases architecture.
Would you store your query in a ssrs report or a database server? State the reason why?
