A table-valued parameter is scoped to the stored procedure, function, or dynamic [!INCLUDE tsql] text, exactly like other parameters. Similarly, a variable of table type has scope like any other local ...