SQL Server 2008 - Table valued parameters

Sign in to queue

Description

If you have to insert more than one row of data in a Table, you end up executing the insert statement / stored procedure as many times for each row, with Table-valued parameters you can send multiple rows of data to a single TSQL statement or stored procedure without creating temp tables or doing multiple round trips.

Table-valued parameters are a new parameter type in SQL Server 2008 and are declared by using user-defined table types.

In this screen cast I am working with SQL server 2008 November CTP or CTP 5 and Visual Studio 2008 RTM bits.

Tag:

SQL Server

Embed

Download

Download this episode

The Discussion

Add Your 2 Cents