---
title: "Table-Valued Parameters (OLE DB Driver for SQL Server) | Microsoft Docs"
description: "Table-Valued Parameters (OLE DB Driver for SQL Server)"
ms.custom: ""
ms.date: "06/12/2018"
ms.prod: sql
ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
ms.reviewer: ""
ms.technology: connectivity
ms.topic: "reference"
helpviewer_keywords: 
  - "OLE DB Driver for SQL Server, table-valued parameters"
  - "table-valued parameters (OLE DB Driver for SQL Server)"
author: pmasl
ms.author: pelopes
---
# Table-Valued Parameters (OLE DB Driver for SQL Server)
[!INCLUDE[appliesto-ss-asdb-asdw-pdw-md](../../../includes/appliesto-ss-asdb-asdw-pdw-md.md)]

[!INCLUDE[Driver_OLEDB_Download](../../../includes/driver_oledb_download.md)]

  Table-valued parameters were introduced in [!INCLUDE[ssKatmai](../../../includes/sskatmai-md.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 [!INCLUDE[tsql](../../../includes/tsql-md.md)], 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 OLE DB, see [Table-Valued Parameters (OLE DB)](../../oledb/ole-db-table-valued-parameters/table-valued-parameters-ole-db.md).  
  
## See Also  
 [OLE DB Driver for SQL Server Features](../../oledb/features/oledb-driver-for-sql-server-features.md)