Looking for sql-server Answers? Try Ask4KnowledgeBase
Looking for sql-server Keywords? Try Ask4Keywords

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.