what is difference between stored procedure and function in sql server?
Function must return a value but in Stored Procedure it is optional( Procedure can return zero or n values). Functions can have only input parameters for it whereas Procedures can have input/output parameters . ... Functions can be called from Procedure whereas Procedures cannot be called from Function.