Microsoft SQL Server 2014 Unleashed

Using Table-Valued Parameters

Table-valued parameters, which were introduced in SQL Server 2008, allow you to pass table variables to stored procedures. Table-valued parameters provide more flexibility and, in many cases, better performance than temporary tables as a means to pass result sets between stored procedures.

Table-valued parameters provide many of the same performance advantages as table data types. Table-valued parameters also share some of the same restrictions as table variables, such as SQL Server not maintaining statistics on table-valued parameters and table-valued parameters not permitted as the target of a SELECT INTO or INSERT EXEC statement. In addition, table-valued parameters can be passed only as READONLY input parameters ...