| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | ||
|---|---|---|---|---|---|---|---|---|---|---|
Table-Valued Parameters |
Table-Valued Parameters (SQL Server Native Client) |
markingmyname |
maghan |
03/14/2017 |
sql |
native-client |
reference |
|
[!INCLUDE SQL Server]
Important
[!INCLUDEsnac-removed-oledb-and-odbc]
Table-valued parameters were introduced in [!INCLUDEsql2008-md], 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 [!INCLUDEtsql], 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).