Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Fetch First vs Fetch Next
Message
From
22/02/2000 10:16:58
Dave Sonier
Technologies Nter inc.
Gatineau, Quebec, Canada
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Fetch First vs Fetch Next
Miscellaneous
Thread ID:
00335372
Message ID:
00335372
Views:
41
Hi,

I used the instruction Fetch First in my code I got this message:

fetch: The fetch type first cannot be used with forward only cursors.

I changed that instruction by Fetch Next and it worked...

So, my question is: in what case is better to use Fetch First and Fetch Next...Tell me a sample ???

Thank in advance...
Next
Reply
Map
View

Click here to load this message in the networking platform