Store Procedure Function
S.P need not be return a value Functions MUST return a value
S.P can be called independently usingexec keyword whereas Function is called using SELECTstatements.

Thank you for reading this post, don't forget to subscribe!

 

S.P can be used for performing business logic

 

Functions are used forcomputations
Can be used EXEC inside an S.P

EXEC command can’t be used inside a Function
S.P takes IN and OUT parameters. Function parameters are always IN, no OUT is possible

 

Transaction related statement can be handled in S.P Can’t be handled in function.

 

XML parameters passed in S.P Can’t pass XML Parameters
S.P can affect the state of the database by using insert, delete, update and create operations. Functions cannot affect the state of the database which means we cannot perform insert, delete, update
Parsed and Compiled during design time itself Compiled and executed during run time