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

Daily Coping 29 May 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Custom Quarantine PoSh Prompt

By

Since I’ve been quarantined at home and working in my office, every day is...

TIL: Get-DbaErrorLog

By

Ed: SQLDork is a Junior DBA on the team here, learning the DBATools in...

Read the latest Blogs

Forums

Daily Coping 29 May 2020

By Steve Jones - SSC Editor

Today’s tip is today link your decisions and choices to your purpose in life....

Week Ending Thursday, can some one tweek my code?

By bark01

What I have missed from this code? I'm trying to show the DateTimeRaised field...

The Matchbox Database

By Phil Factor

Comments posted to this topic are about the item The Matchbox Database, which is...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers