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

Comments closed

Comments have been closed since this content was published more than 30 days ago, but if you'd like to send us feedback you can Contact Us.