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

More PowerShell Remoting coverage in dbatools

By

Starting on dbatools version 1.0.31 we introduced better coverage for commands that make use...

7th Anniversary

By

7 years ago today I posted my very first blog post and I’ll tell...

Beginning T-SQL and Career Roadmap for Women (and Men)! #SQLSatBR

By

Download session materials and watch the recordings of my excellent sessions on Transact-SQL and...

Read the latest Blogs

Forums

Data Migration Assistant errors - dacpac and openquery failures

By yonny24

Hi all, I am attempting to use DMA to assess an upgrade from 2008...

Scalable SSIS Package - Single SSIS package across 50 different projects

By karthik82.vk

Hi All, I have a successfully running SSIS package which has been created for...

Replication Error - TCP Provider: The semaphore timeout period has expired. 

By Joy Smith San

Experts, We are facing an issue with one of the replication subscriber. There were...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers