Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What's the equivalent of VFP's Scan...Endscan in SQL?
Message
De
18/04/2007 08:29:27
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Divers
Thread ID:
01217180
Message ID:
01217239
Vues:
13
OUCH! SQL Server is not good at record processing. Unless you're doing something very simple inside the loop, my guess is it will be faster to pull the data into VFP, process it there, then send it back.

>Hey Guys!
>
>Using SQL2005, I want to create a Stored Procedure that gets set of data, scan it ala Scan...Endscan in VFP, then do some data manipulations inside. Is there any?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform