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

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

19/04/2007 00:05:40

Walter Meester
HoogkarspelNetherlands

To

18/04/2007 02:11:00

Jess Banaga
Bizbox Inc.
Makati, Philippines

General information

Forum:

Microsoft SQL Server

Category:

Stored procedures, Triggers, UDFs

Title:

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

Miscellaneous

Thread ID:

01217180

Message ID:

01217606

Views:

12

>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