Re: [PHP] LIMIT with MSSQL

Zouari Fourat wrote: > Is there anybody who succed in doing per/page listing from a MS SQL Server > db. Sure. > knowing that mssql doesnt support LIMIT like mysql and it uses TOP. Ain't never heard of TOP... But start reading the MS SQL manual about "cursors" to get efficient paging. -- Like

[PHP] LIMIT with MSSQL

Hello Is there anybody who succed in doing per/page listing from a MS SQL Server db. knowing that mssql doesnt support LIMIT like mysql and it uses TOP. i didnt find an optimized way to make a per/page script. Here's what am doing know : to replace a MySQL "SELECT FROM LIMIT $x,$y" i did