SQL Server 2008: Table Valued Parameters

Posted on SQL Team See other posts from SQL Team
Published on Thu, 24 Jul 2008 00:00:00 GMT Indexed on 2010/03/11 4:41 UTC
Read the original article Hit count: 268

Filed under:

In SQL Server 2005 and earlier, it is not possible to pass a table variable as a parameter to a stored procedure. When multiple rows of data to SQL Server need to send multiple rows of data to SQL Server, developers either had to send one row at a time or come up with other workarounds to meet requirements. While a VB.Net developer recently informed me that there is a SQLBulkCopy object available in .Net to send multiple rows of data to SQL Server at once, the data still can not be passed to a stored proc.

Possibly the most anticipated T-SQL feature of SQL Server 2008 is the new Table-Valued Parameters. This is the ability to easily pass a table to a stored procedure from T-SQL code or from an application as a parameter.

© SQL Team or respective owner