Passing TVP instead of Individual Parameters to Procedure
Passing TVP instead of Individual Parameters to Procedure
(OP)
I have been passing parameters to stored procs like this
Sometimes this list of parameters gets extensive (30 - 50). I was thinking of passing a one row table valued parameter that would contain all of the parameters from the .Net project. Actually I already have them in a table. Is this a good idea and do you think it would slow down the execution of the proc?
CODE
@checkmasterpk int ,@companymasterfk int ,@vendmasterfk int ,@companycheckfk int ,@checknbr int ,etc...
Auguy
Sylvania/Toledo Ohio