.NET/SQL Server 2008 - Using Table-Valued Parameters with .NET

home
asp.net
view story

2 Kicks

.NET/SQL Server 2008 - Using Table-Valued Parameters with .NET(syedarizvi.blogspot.com)

submitted by ahmer75(120) 3 years, 3 months ago

With the release of SQL Server 2008, Microsoft introduced a new parameter type called 'Table-Valued Parameters', which provided the flexibility for the SQL developers to send multiple rows of data to a stored procedure/function or inline T-SQL code. Table-Valued parameters can be used to transfer multiple rows of data without requiring the developer to construct custom string parsing routines, temporary table or multiple parameters which for a complex stored procedure can become difficult to maintain.

add a comment |category: ASP.NET |Views: 75
Tweet