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: [email protected]
For additional commands, e-mail: [email protected]
