How do you appropriately limit the query results in the SQL Database Connector using Microsoft SQL. “LIMIT 20” is not the correct syntax in MS SQL, i believe you would use SELECT TOP 20, etc. When I remove the LIMIT text, the query fails. When I include it, I get this error - “Please limit the query to at most 200 entries.” Does anyone have a successful connection to MS SQL Server?
See this example: Pagination / Offset (MSSQL) | SQL Database Connector Pro
That sounds like a syntax error in the SQL