Hi,
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.
Thanks.
Dreamvale
--
PHP Database Mailing List (http://www.php.net/)
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
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