shilpaprele (11/6/2012)
Dear AllI need to create procedure with variable parmaeter list. I am trying to achive it through table value parameter.
Is it the correct approch?
Also I need this parameter to be optional. But when i give folloing syntax i get error
CREATE PROCEDURE [P1]
@param1 VARCHAR(40),
@ParameterTable ParameterTable READONLY = NULL
as
.....
Table-valued parameter is the best for passing table-like data, but not variable parameter list.
Let say you want to pass multiple Customer Id's together with relevant Customer Names. Table-valued parameter is upto this task.
But if you want to pass list of different parameters eg. not-related to each other and having different datatype, I would recommend using XML.