Dmitry Arefiev replied to Stéphane Wierzbicki's topic in Databases
I am remembering / expecting that "{}" are not supported by SQL Server ODBC driver. Really by ODBC itself (the same with other ODBC drivers). Consider that as limitation of FireDAC SQL Server driver, which uses SQL Server ODBC driver internally.
Dmitry Arefiev replied to David Schwartz's topic in Databases
@Lars Fosdal, this feature is supported for 2008 too. In general, it will produce 3 different syntax's depending on SQL Server version. @Attila Kovacs, no, sorry.
Dmitry Arefiev replied to David Schwartz's topic in Databases
SELECT <your query>
OFFSET 19900 ROWS FETCH FIRST 100 ROWS ONLY
That for SQL Server 2012 and higher. Different SQL will be generated for older versions.
Dmitry Arefiev replied to David Schwartz's topic in Databases
http://docwiki.embarcadero.com/RADStudio/Tokyo/en/Fetching_Rows_(FireDAC)#Rows_Paging
FireDAC transparently modifies SQL command and applies keywords like TOP, OFFSET, etc depending on DBMS. So, why "is not something that FireDAC handles well by itself" ?