Microsoft SQL ServerTable Valued Parameters


Table valued parameters (TVP for short) are parameters passed to a stored procedure or function that contains data that is table structured. Using table valued parameters requires creating a user defined table type for the parameter being used.

Tabled valued parameters are readonly parameters.

Related Examples

Using a table valued parameter to insert multiple rows to a table