Walter Meester
HoogkarspelPays-Bas
John Baird
Coatesville, Pennsylvanie, États-Unis
John,
>All of that processing can be as easily done in the sproc using cursors and temptables. You then return the completed dataset to the program. Again, your standard doesn't fly.
I know it can, but just give me the code and compare its performance and compactness.
When talking about the appointment cursor, well you'd better look twice. It is not that easy to solve in SQL server. And above all, you're doing application depended processing on a server. Something that really does not belong there. These type of processing can draw your whole server down as it might consume way too much resource, esspecially when the number of users grow.
And the point here is that the returned resultset probably is way larger than the summ of all tablessize in this example, so also stressing networkbandwidth
Walter,
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