SQL Server 2008 supports
user-defined functions and built-in functions
User Defined Functions includesScalar Functions :
User-defined scalar functions return a single data value of the type defined in the RETURNS clause. For an inline scalar function, there is no function body; the scalar value is the result of a single statement. For a multistatement scalar function, the function body, defined in a BEGIN...END block, contains a series of Transact-SQL statements that return the single value. The return type can be any data type except text, ntext, image, cursor, and timestamp.TableValued Function
User-defined table-valued functions return a table data type. For an inline table-valued function, there is no function body; the table is the result set of a single SELECT statement.Built In Functions:
Built-in functions are provided by SQL Server to help you perform a variety of operations. They cannot be modified.
You can check the below link for more detailshttp://www.dotnet-tricks.com/Tutorial/sqlserver/KY3T010412-Different-Types-of-SQL-Server-Functions.html http://technet.microsoft.com/en-us/library/ms177499(v=sql.105).aspx Please mark my reply as answer if it helps you Saranya Boopathi, if this helps please login to Mark As Answer. | Alert Moderator