Export (0) Print
Expand All

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft