Paging

Dec 12, 2013 at 8:42 PM
For those who are interested. From SQL 2012 on, paging is natively supported in T-SQL by this code:
OFFSET <startindex> ROWS
FETCH NEXT <pagesize> ROWS ONLY;
If you integrate this in
DBSQLClientStatementBuilder::EndSelectStatement()
{
}
You can take advantage of this new functionality (replace existing implementation). Performance is also much higher then older row_number syntax.
Apr 28, 2015 at 9:48 AM
Thanks, didn't realize that library wasn't using the SQL 2012 syntax ... adding code now :-)