Skip to Content.
Sympa Menu

freetds - Re: [freetds] absolute fetches

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddyz77 AT tin.it>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] absolute fetches
  • Date: 08 Apr 2003 09:40:20 +0200

Il lun, 2003-04-07 alle 23:09, Jon Pounder ha scritto:
> Ok, is there any other way then to quickly run through the first n records
> and throw away the results ?
>
> eg: I want rows 100 to 110, from looking at the code now, I gather than to
> implement this, rows 1 to 99 are actually all transferred from the db
> server to the driver and then thrown away, is there any facility for doing
> a fetch_next without actually transferring the data ?
>
>

Well, you can change database system.. I'm kidding :)

Use temporary table and language cursors, use rowcount (or top modifier)

select top 110 * into #res1 from mytable where..

Then skip 100 record and return
I suggest to add a numeric_position column to temporary table and do a
select...

freddy77





Archive powered by MHonArc 2.6.24.

Top of Page