Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
What is the difference between Stored Procedure (SP) and User Defined Function (UDF)?
What is the difference between Stored Procedure (SP) and User Defined Function (UDF)?
✍: Guest
Following are some major differences between a stored procedure and user defined
functions:
UDF can be executed using the “SELECT” clause while SP’s can not be.
UDF can not be used in XML FOR clause but SP’s can be used.
UDF does not return output parameters while SP’s return output parameters.
If there is an error in UDF its stops executing. But in SP’s it just ignores the
error and moves to the next statement.
UDF can not make permanent changes to server environments while SP’s can
change some of the server environment.
2007-10-25, 5491👍, 0💬
Popular Posts:
How Many Tags Are Defined in HTML 4.01? There are 77 tags defined in HTML 4.01: a abbr acronym addre...
Can include files be nested? The answer is yes. Include files can be nested any number of times. As ...
How To Delete a User Account? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privilege...
How do we enable SQL Cache Dependency in ASP.NET 2.0? Below are the broader steps to enable a SQL Ca...
What metrics will you look at in order to see the project is moving successfully? Most metric sets d...