Changes between Version 26 and Version 27 of Docs/Prog/Manual/ApplicationLibraries/lib825mssql

Timestamp:

10/28/26 07:15:05 (3 days ago)

Author:

Don Wilson

Comment:

--

Docs/Prog/Manual/ApplicationLibraries/lib825mssql

@@ -72 +72 @@
 }}}
 
-Microsoft SQL does not have the "LIMIT" clause that SQLite and MySQL have. This clause is commonly used for showing data in pages with "Next" and "Prev" buttons. Microsoft SQL 2012 and above have "OFFSET <offset> ROWS FETCH NEXT <count> ROWS ONLY" that achieves the same function. (Microsft SQL requires "ORDER BY" clause immediately before this. The library //lib825db// has a virtual function !AppendLimitClause to automatically append the correct limit clause syntax. For MySQL or SQL this will append the " LIMIT <offset>,<count>" clause, for SQL Server this will append " OFFSET <offset> ROWS FETCH NEXT <count> ROWS ONLY"
+Microsoft SQL does not have the "LIMIT" clause that SQLite and MySQL have. This clause is commonly used for showing data in pages with "Next" and "Prev" buttons. Microsoft SQL 2012 and above have "OFFSET <offset> ROWS FETCH NEXT <count> ROWS ONLY" that achieves the same function. Microsft SQL requires the "ORDER BY" clause immediately before this. This is also normally included for SQLite and MySQL. The library //lib825db// has a virtual function !AppendLimitClause to automatically append the correct limit clause syntax. For MySQL or SQL this will append the " LIMIT <offset>,<count>" clause, for SQL Server this will append " OFFSET <offset> ROWS FETCH NEXT <count> ROWS ONLY"
 
 {{{#!c++