What is the difference between Stored Procedure , Function
and Package,
1. how many blocks in Package and what are they.
- 5 Answers
- 12171 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 store and query spatial data?
Write a code to select distinct records without using the DISTINCT keyword.
What does the on delete cascade option do?
When you should use a low fill factor?
How to get a list of columns in a view using the "sp_columns" stored procedure?
How can you check the version of sql server?
What do you know about normalization and de- normalization?
Where views are stored in sql server?
What are subqueries in sql server? Explain its properties.
Explain syntax for viewing trigger?
How to concatenate two character strings together?
How can we delete a table in sql server?
How to list all columns in a table using odbc_columns()?
What is not null constraint?
What is database replication?
