Modifying Data with Table-Valued Parameters (Transact-SQL) Table-valued parameters can be used in set-based data modifications that affect multiple rows by executing a single statement. For example, ...