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!

Register Log in
  • Congratulations wOOdy-Soft 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

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.

Similar threads

Shane_SixOne
  • Locked
  • Question
RDLC Parameters
Replies
0
Views
490
Shane_SixOne
Shane_SixOne
grnzbra
  • Locked
  • Question
How Do I Add Column to Middle of Table
Replies
4
Views
885
BobSuruncle
BobSuruncle
grnzbra
  • Locked
  • Question
SELECT TOP 1 of Each of a Group
Replies
5
Views
572
grnzbra
grnzbra
peac3
  • Locked
  • Question
fill the gap of hierarchy data
Replies
11
Views
1K
Chris Miller
Chris Miller
Cpreston
  • Locked
  • Question
Seconds to minutes 2
Replies
5
Views
1K
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top