Table valued function Sclar functions aggregate functions And System functions.

2 Type of Function in Sql Server 1)Scalar Function 2)Table-Valued Function

(1) System Defined FunctionsScalar FunctionAggregate Function (2) User Defined Functions:Scalar FunctionsIn-Line table valued FunctionsMulti-statement table valued Function