Rowset Functions
These rowset functions return an object that can be used in place of a table reference in a Transact-SQL statement.
All rowset functions are nondeterministic; they do not return the same results every time they are called with a specific set of input values. For more information about function determinism, see Deterministic and Nondeterministic Functions.