db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Fox <Thomas....@seitenbau.net>
Subject RE: use native limit/offset solution for mssql
Date Wed, 18 Apr 2012 11:27:27 GMT
Greg Monroe wrote:

> Closing sounds good... but we might want to think about an MSSQL2012 DB
> Adaptor that uses the new OFFSET / FETCH support... but since this is
> a new server release, that can wait a bit until it's more widespread.

A new adapter is fine. Do you have a MSSQL2012 instance to test against
(ahem... is it already released )?

    Thomas

>
> Here's some info about this:
>
> --- From StackOverflow ---
> This is working but sql server 2012 onwards. Limit with offset to
> select 11 to 20 rows in sql server:
>
> SELECT email FROM emailTable WHERE id=3
> OFFSET 10 ROWS
> FETCH NEXT 10 ROWS ONLY;
> //offset - no. of skipped rows
>
> //next - required no. of next rows
>


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org


Mime
View raw message