A single rowset is returned by a table-valued function (unlike stored procedures, which can return multiple result shapes). Because a table-valued function’s return type is Table, you may use it wherever in SQL that a table can be used.