Answer: User-Defined Functions allows to define custom T-SQL functions that can accept zero or more parameters and return a single scalar data value or a table data type.
In terms of functionality it is similar to C# or VB.NET functions except the fact that code is written in T-SQL :)
For more visit
http://www.sqlteam.com/article/user-defined-functions
Thanks