How to handle complex scenarios with TVPs? Table-valued parameters (TVPs) are a powerful feature of T-SQL stored procedures that allow you to pass a table as an argument to a procedure.