SQL Server - Multi Statement Table valued function

A multi-statement table-valued function or MSTVF is a table-valued function that returns the result of multiple statements. ... To define a multi-statement table-valued function, you use a table variable as the return value. Inside the function, you execute one or more queries and insert data into this table variable.

#practicalit #sqlserver #learnsql #sqlfunction