Execute Table-Valued Functions in SQL Server using the SQL adapter

The Transact-SQL and CLR table valued functions in SQL Server are surfaced as operations in Microsoft BizTalk Adapter for SQL Server. The operation name in the SQL adapter is the same as the name of the table valued function in SQL Server.

All the parameters in the table valued function are exposed in the corresponding operation. If you do not specify an input parameter for a table valued function, the SQL adapter internally invokes the function using the DEFAULT keyword. This implies that the table valued function is executed using the default value specified while defining the function.

For more information about:

See Also

What Operations Can be Performed Using the Adapter?