Pagination Error 'Incorrect syntax near OFFSET' using SQL Server
I am developing a project using Filament 3 and Laravel 11 with SQL Server as the database. I'm using the default table provided by Filament, and since the dataset is large, I tried implementing the default pagination.
However, when I tested it, I encountered an error:
SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server] Incorrect syntax near 'OFFSET'.
(Please refer to the attached screenshot for details.)
Interestingly, if I don’t apply pagination and select 'All' to display all data, it works fine. However, this is not efficient for large datasets.
Could you please help me understand why this error is happening and how to fix it?
However, when I tested it, I encountered an error:
SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server] Incorrect syntax near 'OFFSET'.
(Please refer to the attached screenshot for details.)
Interestingly, if I don’t apply pagination and select 'All' to display all data, it works fine. However, this is not efficient for large datasets.
Could you please help me understand why this error is happening and how to fix it?
