SQL - Table Function


PIPELINED functions (or table function) operate like a table and is a good workaround to Stored Procedures

They are useful if there is a need for a data source other than a table in a select statement.


Without the table(…) wrapper

With the table wrapper:

Not implemented:

Example with table wrapper:

SELECT W FROM tablefunc(a,b)

Powered by ComboStrap