limit record in mssql

Anon

By using MYSQL , we can limit record per page
by using "LIMIT".

How about mssql ???
how do i limit record return ?

p/s : no using ADO.

thanks for ur answer

totof06

Try:

set rowcount number_of_rows

to restore the Sql server default:

set rowcount 0

Anon

What I've done with Sybase, and you can do it with any other database, is return the whole list. But only print out the ones you want to return. So just loop through your results and if the row is in the range you want print it, otherwise skip it. I'm not sure if this will slow down page loading, but it hasn't seemed to cause any problems here.

Anon

how about i want to display from record
no. 5 to no. 10 ???

Anon

Well, the way we went about doing it is select all of them....Let's say it's 100. And then do as such...

//queryCount is however many per page (we had
//15 results per page). offset is the query
//we finished with on the last page.

while ($ary = sybase_fetch_array($returnQuery)) {
if (($queryCount > $offset) && ($queryCount <= ($offset+$queryLimit))){
echo "$ary[0]";
}
}

hope this helps you out. You can easily edit this to fit your needs.

Anon

then all the records will pass to other user,
i think that will be slow.
do you think so ?