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.
Watch the screencast(SWF)
Watch the screencast(WMV)
Showing posts with label Table valued parameters. Show all posts
Showing posts with label Table valued parameters. Show all posts
Saturday, December 01, 2007
Subscribe to:
Posts (Atom)