Table Valued Parameters (TVP)

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

Table-valued parameters – SQL Server 2008

by Additional Articles

Database Journal

Table Valued Parameters (TVP)

Article

In previous versions of SQL Server, it has not been possible to pass a table variable, as a parameter, to a stored procedure. Microsoft introduces table-valued parameters, along with other features, in SQL Server 2008. This article illustrates the function and usage of table-valued parameters.

2008-06-02

2,812 reads

Question of the Day

I have some data in a table that looks like this:

BeerID BeerName brewer beerdescription 1 Becks Interbrew Beck's is a German-style pilsner beer 2 Fat Tire New Belgium Toasty malt, gentle sweetness, flash of fresh hop bitterness. 3 Mac n Jacks Mac & Jack's Brewery This beer erupts with a floral, hoppy taste 4 Alaskan Amber Alaskan Brewing Alaskan Brewing Amber Ale is an "alt" style beer 8 Kirin Kirin Brewing Kirin Ichiban is a Lager-type beer

select t1.[key] from openjson((select t.* FROM Beer AS t for json path)) t1

See possible answers

Table Valued Parameters (TVP)

Table valued parameter

TVP

SQL Server 2008: Table Valued Parameters

Table-valued parameters – SQL Server 2008

Blogs

Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption

Why your data still can’t answer a simple question

T-SQL Tuesday #197 Invitation – An impactful session or two from a conference

Forums

The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI

Daily aggregation of Azure Blob Storage by tier (created/tier-change/deleted)

SQL 2017 to SQL 2025. Good to Go ?

Question of the Day

Using OPENJSON