Tag Archives: SQL Server

Using JSON to move beyond TVPs for multi-row updates

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… Read more »