Re: LIMIT with MSSQL
| From: | Richard Lynch | Date: | Wed, 26 Jan 2005 20:44:36 +0000 |
| Subject: | Re: LIMIT with MSSQL | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-207420@lists.php.net to get a copy of this message | ||
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 Music?
http://l-i-e.com/artists.htm