SQL syntax error: Incorrect syntax near 'LIMIT'

Description

We get the attached error when using a Play SQL Query macro. It is occurring against MS SQL Server databases (2008 or 2012) using either the JTDS or Microsoft JDBC drivers.

Play SQL Version 2.10.10

However, the Legacy macro is working fine.

Any help is appreciated.

Environment

None

Observations

None

Assignee

Adrien Ragot (Play SQL / Requirement Yogi)

Reporter

Ryan Williams

Labels

None

Participants

None

Components

Fix versions

Priority

Configure