Re: (OT) MSSQL - get records #n...n+10?
| From: | Ignacio Vazquez-Abrams | Date: | Thu, 14 Dec 2000 00:30:02 +0000 |
| Subject: | Re: (OT) MSSQL - get records #n...n+10? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-30223@lists.php.net to get a copy of this message | ||
On Thu, 14 Dec 2000, Josh G wrote:
> Hi, just wondering, is there an easy way in MS-SQL to get records
> #n...#n+10 like mysql's limit keyword?
>
> Cheers,
>
> Gfunk
>
> http://www.gfunk007.com/
>
Yes, but it's not pretty. You have to use cursors and then go through them one
row at a time. At least, that's how I believe it would have to be done.
--
Ignacio Vazquez-Abrams <ignacio@openservices.net>