Table Valued Parameters (TVP)

SQL Server 2008: Table Valued Parameters

  • Article

In SQL Server 2005 and earlier, it is not possible to pass a table variable as a parameter to a stored procedure. When multiple rows of data to SQL Server need to send multiple rows of data to SQL Server, developers either had to send one row at a time or come up with other workarounds to meet requirements. While a VB.Net developer recently informed me that there is a SQLBulkCopy object available in .Net to send multiple rows of data to SQL Server at once, the data still can not be passed to a stored proc.

2008-08-11

3,885 reads

Blogs

Azure SQL Database Compatibility with SQL Server

By

A long time ago, in early days of the Azure SQL Database in 2015,...

Custom deployment parameters in Azure Data Factory - Forget Me Not

By

(2020-Sep-26) Last week one of my Azure Data Factory (ADF) deployment pipelines failed with an...

VMworld 2020 – Top 10 Database Sessions (Part 2)

By

Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member...

Read the latest Blogs

Forums

about the option (fast n) and acutal execution plan

By 892717952

 what kind of situation  can I use "option (fast 1)"  when I execute a...

Problem during the setup of SQL Server 2019

By Developper12345678

During the installation I come to the step of configuring the database engine. It...

A Getting Started PostgreSQL Tutorial

By Shivayan Mukherjee

Comments posted to this topic are about the item A Getting Started PostgreSQL Tutorial

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers