MSSQL does not have complete the same functions. You can use SELECT TOP 10.
You could also define mssql.batchsize in php.ini. This way php only reads the
specified number of rows. You can the use mssql_fetch_batch() to read batches of data
on the same query.
- Frank
> Hi,
>
> Having used to
Hello Dreamvale,
On 20-Jun-01 12:15:14, you wrote:
>Having used to the wonderful features in MySQL on the limit, how could I do
>the same on MSSQL?
>The table I'm trying to retrieve is kinda big - like 500,000 records - and
>would like to read them in chunks.
Use server side cursors.
You may