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?
Auguy
Sylvania/Toledo Ohio
Code:
@checkmasterpk int
,@companymasterfk int
,@vendmasterfk int
,@companycheckfk int
,@checknbr int
,etc...
Auguy
Sylvania/Toledo Ohio