I 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]
@ParameterTable ParameterTable READONLY = NULL
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.
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)How to post your question to get the best and quick help