Anil Singh | Code-sample.com

What is a function in SQL Server? A SQL function is a set of statements that you can pass input values, perform an action and return the result and the result can be single value or a table value. When do you use SQL function? When I am writing an expression and I want to return some value in the SELECT statement from this expression that time I can use a function. Types of SQL functions, 1) System defined functions ·          Scalar Functions : - abs, round, upper, lower, trim and convert etc. ·          Aggregate Functions : - min, max, avg and count etc. 2) User defined functions The user defined functions are created in the user defined database. This user defined function can be “inline table valued function”, “scalar value function” or “multi statement table valued function”. Syntax:- CREATE FUNCTION < Scalar_Function_Name, sysname, FunctionName > ( ...