Create a BizTalk project, and generate schema for the table-valued function you want to invoke in SQL Server. Create messages in the BizTalk project for sending and receiving messages from SQL Server.

A table-valued function returns a single rowset (unlike stored procedures, which can return multiple result shapes). Because the return type of a table-valued function is Table, you can use a ...