Table-Valued Parameters

Articles about Table-Valued Parameters

1. 
   Article · SQL Server

   Efficient Data Handling in SQL Server with Table-Valued Parameters

   This article delves into how TVPs enhance performance by enabling the transfer of multiple rows of data in a single parameter, streamlining stored procedures, and optimizing database operations.

   Sanjay KumarOct 27, 20242,1011,000
   
2. 
   Article · SQL Server

   Table(s): Temp Table, Table Variable and CTE (Common Table Expression)

   This article will discuss SQL Table like items, including temp table, table variable, CTE, Table-valued Parameters.

   GeorgeAug 1, 20245,5441,000
3. 
   Article · SQL Server

   MERGE Stored Procedures in SQL Server

   In this article, I present how to use the MERGE statement in a stored procedure to merge a single record and how to use it to merge a list of records by using Table-Valued parameters in SQL Server.

   Jitendra MesavaniyaApr 16, 20243,7131,000
   
4. 
   Article · SQL Server

   Table-Valued Parameters in SQL Server

   Table-Valued Parameters in SQL Server enable passing multiple rows of data to stored procedures, enhancing performance for bulk operations. Utilizing user-defined table types, they streamline data manipulation tasks and allow parameterized queries, optimizing database development and improving overall performance.

   Jitendra MesavaniyaApr 16, 20243,8671,000
   
5. 
   Article · SQL Server

   User Defined Table Types And Table Valued Parameters

   In this article you will learn about User Defined Table Types and Table-Valued Parameters. The concepts of User-Defined Table Types (UDTTs) and Table-Valued Parameters (TVPs) were introduced in SQL Server 2008.

   Pankaj Kumar ChoudharyOct 13, 2023682,7911,000
   
6. 
   Article · .NET

   Using Table Valued Parameters in Entity Framework

   In this article I am explaining the use of Table Valued Parameters (TVPs) using Entity Framework.

   Ritesh SharmaNov 11, 2020229,5271,000
7. 
   Article · SQL Server

   Passing A Table To A Stored Procedure In SQL Server Using Table Valued Parameters

   In this article you will learn how to pass a table to a stored procedure in SQL Server using table valued parameters.

   Rajeev PunhaniJan 25, 201679,8131,000
8. 
   Article · SQL Server

   Table Valued Parameters in SQL 2008

   This article describes Table Valued Parameters in SQL 2008 and how they can be used with C# code.

   Vikram ChaudharyFeb 25, 20157,0621,000