sql procedures and functions Archives - Coddicted

Stored Procedures and Functions

Difference between Stored Procedures and Functions   Stored procedures are a set of actions  already written  and stored inside database  for achieving a particular task. Functions are general databse objects which are  used for general purpose programming.        S.No.                                  Stored Procedures                                             Functions  1.  Procedures may return none or more values  Functions must always return one value either a ...