Ø
User Defined Function can be
executed using the "SELECT" clause whereas Stored Procedure cannot be Executed..
Ø
User Defined Function does not return any output
parameters while Stored Procedure will return output parameters.
Ø
User Defined Function cannot
make permanent changes to server environments while SP's can change some of the
server environment.
Ø
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.
No comments:
Post a Comment