Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Complex sql statement in BO?
Message
Information générale
Forum:
ASP.NET
Catégorie:
The Mere Mortals .NET Framework
Divers
Thread ID:
01260843
Message ID:
01260874
Vues:
12
Patrick,

Even in situations where the user can select from multiple criteria (user enters some parameters, and leaves others blank), I still generally recommend stored procs.

You can define all the possible parameters in the stored proc, given them NULL default values, and use T-SQL functions like ISNULL or COALESCE in your stored proc. Additionally, if you're using SQL 2005 as your database, you can take advantage of the new XML capabilities in SQL 05 to process a variable list of key selections.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform