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.

You can use the [!INCLUDEadaptersqlshort] in a .NET application using the WCF service model to invoke table-valued functions in SQL Server. The adapter exposes the table-valued functions as methods ...

If you work with data in SQL Server, you probably use functions to manipulate, transform, or aggregate values. But did you know that there are two types of functions in T-SQL: scalar and table-valued?

SQL Server 2008 introduces the ability to pass a table data type into stored procedures and functions. The table parameter feature can greatly ease the development process because you no longer ...

SQL functions allow you to encapsulate logic that returns a single value or a table. SQL functions are particularly useful for performing calculations, formatting data, and reusing logic across ...

Thanks Chris. Do you know if PBI uses query folding on custom sql (on all sources) ? If it does and it’s smart i.e. detects a single SELECT statement and adds or expand the WHERE predicate, ...

This article explains how to add spatial search functions (point-near-point and point in polygon) to Microsoft SQL Server™ 2005 using C# and table-valued functions. It is possible to use this library ...

Value window functions are like aggregate window functions that perform multiple operations in a window, but they’re different from aggregate functions. They include things like LAG() , LEAD ...

Teo Lachev has already stolen my thunder and blogged about how the new functionality allows you to use a TSQL stored procedure as the source of a table in DirectQuery mode. In this post I’m going to ...