| title | Table-Valued Parameters (SQL Server Native Client) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 03/14/2017 | ||
| ms.prod | sql | ||
| ms.reviewer | |||
| ms.technology | native-client | ||
| ms.topic | reference | ||
| helpviewer_keywords |
|
||
| ms.assetid | 5ee6bdcd-0309-4a20-b5c2-0e6b6839f34f | ||
| author | MightyPen | ||
| ms.author | genemi | ||
| manager | craigg | ||
| monikerRange | >=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current |
[!INCLUDEappliesto-ss-asdb-asdw-pdw-md] [!INCLUDESNAC_Deprecated]
Table-valued parameters were introduced in [!INCLUDEssKatmai], 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).