Pass Tables to Stored Procedure / Table Valued Parameter
Posted by: ASPAlliance.com - The #1 ASP.NET Community,
on 06 Nov 2009 |
View original | Bookmarked: 0 time(s)
When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a SQLBulkCopy object available in .NET to send multiple rows of data to SQL Server at once, but this still cannot be passed to a stored procedure.
SQL Server 2008 provides a new feature called "Table-Valued Parameters". This provides us the ability to easily...