User-Defined Functions allow to define its own T-SQL functions that can accept 0 or more parameters and return a single scalar data value or a table data type.
SHASHANGKA SHEKHAR'S BLOG
Technical Author | CodeProject MVP | C# Corner MVP