User-defined functions can't call a stored procedure, but can call an extended stored procedure. User-defined functions can't make use of dynamic SQL or temp tables. Table variables are allowed. SET ...

Although this falls naturally within the scope of relational databases, many such tasks cannot be expressed in SQL and require additional expressive power achieved via user-defined functions (UDFs).