Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Passing TVP instead of Individual Parameters to Procedure

Status
Not open for further replies.

Auguy

Programmer
May 1, 2004
1,206
US
I have been passing parameters to stored procs like this
Code:
	@checkmasterpk int
    ,@companymasterfk int
    ,@vendmasterfk int
    ,@companycheckfk int
    ,@checknbr int
    ,etc...
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top