Demo: Table-Valued Parameters

This demo shows how to use table-valued parameters in SQL Server 2008 to send multiple rows of data to Transact-SQL statements or routines, without creating temporary tables or additional parameters. It illustrates how to declare user-defined table types and use them to define strongly typed table variables, and how to pass these table variables as parameters to stored procedures and functions. The demo compares alternative approaches to see how table-valued parameters provide and efficient solution that minimizes the number of round trips required to send multiple rows of data.