Pass Tables to Stored Procedure / Table Valued Parameter

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 This provides us the ability to easily pass a table to a stored procedure from T-SQL code or from an application as a parameter.

Read More...

---