Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ORDER BY in Stored Proc
Message
De
12/02/2009 00:43:04
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, États-Unis
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
01381103
Message ID:
01381156
Vues:
35
>I have heard it argued that it's not a good idea to do ORDER BY's in a stored proc or client side SQL because it can slow things down.
>I know I can sort the data any way I want in the UI, but does anyone agree with this POV?
>
>Thanks

I see no problems doing order by in your query. I've seen the order by done somewhat dynamically so you can pass in a parameter to tell you how to order it.
Very fitting: http://xkcd.com/386/
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform