Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What's the equivalent of VFP's Scan...Endscan in SQL?
Message
From
18/04/2007 08:29:27
 
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Miscellaneous
Thread ID:
01217180
Message ID:
01217239
Views:
14
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform