Difference between procedure and function

Function must return a value, but in Stored Procedure it is optional. Function takes one input parameter it is mandatory ,but Stored Procedure may take 0 to n input parameters..

Function can return at most one value at a time while procedure can return more than one value at a time You can use function within Sql Statement and you cannot use stored procedure with in Sql Statement

In case of storedprocedure transformation procedure will be compiled and executed in a relational data source. U need data base connection to import th