Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Variable number of parameters to sql stored procedures
Message
From
22/07/2007 12:14:48
Mike Yearwood
Toronto, Ontario, Canada
 
 
To
22/07/2007 11:23:06
Bonnie DeWitt
Geneva Systems Group
Ellensburg, Washington, United States
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Re: Variable number of parameters to sql stored procedures
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01242588
Message ID:
01242623
Views:
35
>>Does no one see how inefficient it is to write 20 variations of the same query just to support multiple parameters?
>
>Where are you getting that from? I didn't see anyone recommending that.

http://sqlserver2000.databases.aspfaq.com/can-i-have-optional-parameters-to-my-stored-procedures.html

It looks like he's recommending having stored procedures GetAuthors1 - GetAuthors. Maybe that's just his way of showing execution plans?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform