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 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 unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
