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.


3,885 reads


More PowerShell Remoting coverage in dbatools


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

7th Anniversary


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


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

Read the latest Blogs


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


SQL Server Q&A from the SQLServerCentral community

Get answers