Many .NET applications will use Table-Valued-Parameters (TVPs) to send in a set of rows to be updated to a single stored procedure. Using this approach requires a decent amount of legwork to achieve: Define a TYPE in SQL Server to represent the table valued parameter Assign permissions to the TYPE so that it can be …

Read More

A common challenge with stored procedures is how to pass in multiple rows to a single stored proc call — especially when you know all of the new / updated rows at a single time. Doing so can save on round trips as well as (sometimes) making transaction handling easier. Failed Attempt 1: Just use flat parameters If you …

Read More