What's the equivalent of VFP's Scan...Endscan in SQL? - Level Extreme

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

19/04/2007 00:05:40

Walter Meester
HoogkarspelPays-Bas

À

18/04/2007 02:11:00

Jess Banaga
Bizbox Inc.
Makati, Philippines

Information générale

Forum:

Microsoft SQL Server

Catégorie:

Stored procedures, Triggers, UDFs

Titre:

Re: What's the equivalent of VFP's Scan...Endscan in SQL?

Divers

Thread ID:

01217180

Message ID:

01217606

Vues:

11

>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?

Search for FETCHING and CURSORS in SQL books online. However SQL server is not really optimized for RECORD ORIENTED processing, you might be dissapointed in performance though.

Click here to load this message in the networking platform