Friday, 5 December 2014

Difference between Function and Store Procedure in Sql Server

Basic Difference:-

  1. Function must return a value but in Stored Procedure it is optional( Procedure can return zero or n values).
  2. Functions can have only input parameters for it whereas Procedures can have input/output parameters .
  3. Functions can be called from Procedure whereas Procedures cannot be called from Function.

No comments:

Post a Comment