FreeTDS Development Group

["Vitor Pinho" <vpp AT sageinfologia.com>]

I already tried this, but I can't change all my SQL instructions and
I want to use just one function that process the same SQL instruction in
MySql and SqlServer in order
to return the resultset.

Thanks anyway,
Vpp


-----Original Message-----
From: bounce-freetds-138221 AT franklin.oit.unc.edu
[mailto:bounce-freetds-138221 AT franklin.oit.unc.edu]On Behalf Of
Winkless, Geoff
Sent: sexta-feira, 9 de Novembro de 2001 13:43
To: TDS Development Group
Subject: [freetds] Re: Implementation of select Limit


> Maybe I didn't make myself clear. I don't want the top n records.
>
> I need the n top with an offset. For example:

You could try

SELECT IDENTITY(INT, 1, 1) id, *
INTO #temp
FROM blah

SELECT * FROM #temp WHERE id BETWEEN 10 AND 20

Geoff

---
You are currently subscribed to freetds as: [vpp AT sageinfologia.com]
To unsubscribe, forward this message to
$subst('Email.Unsub')