A User-Defined Table Function (UDTF) is designed to return a set of rows, which means it can be accessed in the FROM clause of a query. Scalar User Defined Functions (UDFs), stored procedures, and tasks do not return sets of rows in a way that allows them to be used in the FROM clause. Scalar UDFs return single values, stored procedures are for procedural logic, and tasks are for scheduling jobs.