Since SQL Server 7, stored procedures and user-defined functions ... If you can't wait for Microsoft to produce everything you want as extensions to T-SQL or as system-defined functions, then ...

In SQL Server, a function that returns a single value is known as a “scalar UDF” or “scalar user defined function”. These scalar UDFs are automatically categorized as deterministic or non ...