Transact-SQL
(T-SQL) functions are subprograms that encapsulate a sequence of T-SQL
statements. T-SQL functions can return a single scalar value, a single row, or
multiple rows.
There are two types
of T-SQL functions:
·
Scalar
functions: return a single scalar value, such as an integer, a string, or a
date/time value.
·
Table-valued
functions:...