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:
Using the SQL adapter with BizTalk Server to invoke table valued functions in SQL Server, see Invoking Table-Valued Functions in SQL Server by Using BizTalk Server.
Message structure and SOAP actions for table valued functions, see Message Schemas for Procedures and Functions.