Anteckning
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
The Table-valued Function operator evaluates a table-valued function (either Transact-SQL or CLR), and stores the resulting rows in the tempdb database. When the parent iterators request the rows, Table-valued Function returns the rows from tempdb.
Queries with calls to table-valued functions generate query plans with the Table-valued Function iterator.
In SQL Server 2000, Table-valued Function is evaluated with parameters (those of the table-valued function itself) that are constant within a plan. In SQL Server 2005, Table-valued Function can be evaluated with different parameter values.
Table-valued Function XML Reader inputs an XML BLOB as a parameter and produces a row set representing XML nodes in XML document order. Other input parameters may restrict XML nodes returned to a subset of XML document.
Table Valued Function XML Reader with XPath filter is a special type of the XML Reader Table-valued Function that restricts output to XML nodes satisfying an XPath expression.
Table-valued Function is a logical and physical operator.
.gif "Table-valued function operator icon")
Graphical execution plan icon
See Also
Tasks
How to: Display an Actual Execution Plan
Concepts
Logical and Physical Operators Reference
Displaying Execution Plans by Using the Showplan SET Options (Transact-SQL)
Table-valued User-defined Functions