RE: [PHP] MSSQL - Previous/Next Paging Results
| From: | Dan Joseph | Date: | Tue, 10 Jun 2003 16:25:25 +0000 |
| Subject: | RE: [PHP] MSSQL - Previous/Next Paging Results | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-150938@lists.php.net to get a copy of this message | ||
Hi,
> -----Original Message-----
> MSSQL seems to be a little bit messier that MySQL..e.g limit clause etc
>
> Anyone know of articles/examples that specifically deal with this issue?
Look into the Top() function for MSSQL. It goes something like:
SELECT Top(10) * FROM table
You should be able to find some info under the msdn.microsoft.com page.
Or, MS has several hundred newsgroups, they should have one for MSSQL.
-Dan Joseph