Microsoft® SQL Server 2012 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.

Note

For more information on using temporary tables and the table data type in stored procedures, see Chapter 46.

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