Tabular

Tabular functions return a result set — a table of rows — rather than a single scalar value.

Function	Description
sys.dm_db_stats_properties	Returns when the statistics of a table were last calculated and how much it has changed since.
fn_builtin_permissions	Returns a description of the all built-in permissions hierarchy of the server.
fn_helpcollations	Returns a list of all collations.
fn_listextendedproperty	Returns extended property values of database objects.
GENERATE_SERIES	Returns a table of numbers from a start value to a stop value, in steps of a given size.
OPENJSON	Parses JSON text into rows and columns.
OPENQUERY	Runs a query on a connected source.
OPENROWSET	Reads external data as a table.
STRING_SPLIT	Splits a string into rows of substrings at a single-character separator.