Q:- What Is Difference Between Procedure And Function In Asp.Net?
|
PROCEDURE
|
FUNCTION
|
||
|
1
|
Procedure can return zero or n values
|
1
|
function can return one value which is mandatory
|
|
2
|
Procedures can have input, output parameters for it
|
2
|
Function can have only input parameters.
|
|
3
|
Procedure allows select as well as DML(INSERT/UPDATE/DELETE) statements
in it
|
3
|
Function allows only select statement in it.
|
|
4
|
Procedures cannot be called from function.
|
4
|
Functions can be called from procedure
|
|
5
|
Exception can be handled by try-catch block in a procedure
|
5
|
Try-catch block cannot be used in a function.
|
|
6
|
Stored Procedure is a group of sql statements that has been created
once and stored in server database.
|
6
|
Function is not pre-compiled object it will execute every time
whenever it was called.
|
|
7
|
Return type is not must
|
7
|
Return type is must
|
Farture Fartures Ford Escape Titanium | Titanium Arts
ReplyDeleteA stunning and titanium dab nail innovative Farture Farture Farture Fartures are designed for high-quality high gold titanium quality Fartures. Use the cutting edge apple watch titanium and create titanium muzzle brake your own citizen super titanium armor Fartures.