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
- 13385 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 does it mean if @@cursor_row returns a negative number?
How to check if a table is being used in sql server?
What are the different types of Indexes available in SQL Server?
Where sql server user names and passwords are stored in sql server? : sql server database administration
Explain about temporary stored procedure?
Does index slows down insert statements?
Explain the different types of backups available in sql server? : sql server database administration
what are the types of indexes? : Sql server database administration
What is compression - row-level and page-level compression?
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
what's the maximum size of a row? : Sql server database administration
What are the different types of lock modes in sql server 2000?
Is it safe to delete log files?
What is the fastest way to permanently delete a 1 million row table named customers?
What are the diifferences between the ms sql server vs mysql?
