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
- 13184 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
How to Insert multiple rows with a single insert statement?
What is the Difference Between Primary and Foreign Key?
What is stored in the mssqlsystemresource database? : sql server database administration
What are the operating modes in which database mirroring runs?
What are the different types of columns types constraints in the sql server?
What is public role in sql server?
what is checksum in sql server.........???
What is the need for indexing?
How do I debug a stored procedure in sql server?
Explain what is dbcc?
What is the difference between varchar and nvarchar datatypes?
what is normalization? : Sql server database administration
How to create an multi-statement table-valued function?
When would you prefer to have a minimum number of indexes?
How are the unique and primary key constraints different?
