Skip to content

table-valued-parameters-sql-server-native-client.md

Latest commit

 

History

History
39 lines (32 loc) · 2.08 KB

table-valued-parameters-sql-server-native-client.md

File metadata and controls

39 lines (32 loc) · 2.08 KB

title: "Table-Valued Parameters (SQL Server Native Client) | Microsoft Docs" ms.custom: "" ms.date: "03/14/2017" ms.prod: "sql" ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw" ms.service: "" ms.component: "native-client|features" ms.reviewer: "" ms.suite: "sql" ms.technology:

ms.tgt_pltfrm: "" ms.topic: "reference" helpviewer_keywords:

  • "SQL Server Native Client, table-valued parameters"
  • "table-valued parameters (SQL Server Native Client)" ms.assetid: 5ee6bdcd-0309-4a20-b5c2-0e6b6839f34f caps.latest.revision: 14 author: "MightyPen" ms.author: "genemi" manager: "craigg" ms.workload: "Inactive" monikerRange: ">= aps-pdw-2016 || = azuresqldb-current || = azure-sqldw-latest || >= sql-server-2016 || = sqlallproducts-allversions"

Table-Valued Parameters (SQL Server Native Client)

[!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).

See Also

SQL Server Native Client Features