Can you use LIMIT on mssql? I can’t here:
SQL Server 9.0.3054
SELECT * FROM [SomeTable] LIMIT 0,15
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near ‘0’.
SELECT * FROM [SomeTable]
<returned rows here>
This is via MS SQL management Studio though, not via PHP. Could be different maybe?