May 2019
Intermediate to advanced
484 pages
11h 23m
English
A User-Defined Function (UDF) is like a stored procedure in that it is a block of T-SQL statements saved as an object, but it differs in that it does not generate a result set, it returns a value of a specified type. A scalar UDF is a function that returns a single value, a Table-Valued Function (TVF) is a function that returns a table.
There are two types of TVFs in SQL Server:
The following is ...