Ms sql limit.

Anon

I use Ms SQL Database and Php.

I limit the result retrieve from database by below query :
Select * from table Limit 0,10;

But don't work.

Thanks for answering.

totof06

MS SQL doesn't support 'limit'. Try with 'between'

Chris.

http://www.realscale.com

bobby

Limit doesn't work in MS SQL. You have to use 'TOP'.

The biggest disadvantage with Top is that you can't start from anywhere in the set of selected records, but from top.

SELECT TOP 10 * FROM tablename;

saloon12yrd

Hi,

as Christophe pointed out BETWEEN should work but you can move the internal row pointer of nearly any database with the data_seek() function.
for mysql: mysql_data_seek(int result_identifier, int row_number)

for mssql:
mssql_data_seek (int result_identifier, int row_number)

and so on. This produces PORTABLE code which I believe to be a good thing.

Greets,

Dominique

Anon

Hi,
I try to use 'between' but didn't work too. I used odbc connect to the database.

Anon

Hi,

'Top' it's work well but I want to have the next page then I can't use 'Top'

Anon

Hi,
I used odbc connect to the database I didn't use mssql. Then how I shoud to do?