Export (0) Print
Expand All
0 out of 1 rated this helpful - Rate this topic

Table-Valued Parameters (SQL Server Native Client)

Table-valued parameters were introduced in SQL Server 2008, and provide an efficient way to pass multiple rows of data to the server. Table-valued parameters provide functionality similar to parameter arrays, but they offer more flexibility and closer integration with Transact-SQL, and can frequently improve performance. Table-valued parameters can also participate in set-based operations, whereas parameter arrays cannot.

For information about table-valued parameters and ODBC, see Table-Valued Parameters (ODBC).

For information about table-valued parameters and OLE DB, see Table-Valued Parameters (OLE DB).

For information about sample applications that demonstrate this feature, see Considerations for Installing SQL Server Samples and Sample Databases.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.