29.SQL Server - Table Valued Functions (TVF) | Inline Table Valued Functions

In this class we discuss about Inline Table Valued functions:

SQL Table-Valued Function (TVF) is a user-defined function that returns a table as a result set. Unlike scalar functions that return a single value, a TVF can be used to encapsulate a complex logic that generates and returns a table of data. TVFs are particularly useful when you need to perform a set of operations on a dataset and return the result as a table, which can then be used in a query like a regular table or joined with other tables.

-- Table Valued Functions

-- TVFS we can use used after FROM clause in the SELECT statements.
-- Tvfs can be categeorized into two types
--i. Inline
--ii. Multi- statement table valued

-- Synatx for the Inline Table Valued Funtcions

-- CREATE
-- RETURNS TABLE
-- AS