Query Limit in MS SQL Server

anon46566030 · 2024-12-09T16:19:22.110Z

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?

bubble.trouble · 2024-12-09T16:26:14.937Z

See this example: Pagination / Offset (MSSQL) | SQL Database Connector Pro

anon46566030 · 2024-12-09T16:55:29.856Z

this only ever returns the following:

image498×232 7.7 KB

bubble.trouble · 2024-12-09T17:10:42.473Z

That sounds like a syntax error in the SQL