John Baird
Coatesville, Pennsylvanie, États-Unis
Information générale
Forum:
Microsoft SQL Server
Versions des environnements
SQL Server:
SQL Server 6.5 and older
>>>
>>>
>>>It's possible for any combination of parameters to be passed. How do I change the WHERE clause to handle this?
>>>
>>>Thanks
>>
>>Loop through the parms collection and build the where clause dynamically...
>
>I don't think running dynamic SQL is a good idea. If there are few parameters, using NULIF or ISNULL functions I would expect to be quicker.
If you read the question carefully, you'll see the following statement: It's possible for any combination of parameters to be passed. How do I change the WHERE clause to handle this?
Notice the "its possible for ANY COMBINATION OF PARAMETERS". How do you account for getting 1 or 5 or 15?
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement