Hello All!
I am implementing a database application using PHP4 and MSSQL2000. I have a database
table which has a large no. of tuples. I want to display the data in the form of pages
with Prev Next buttons.
I wanted to know if there is some syntax in the MSSQL Select statement which can allow
me to limit the no. of records being returned. I am lookin at functionality which is
similar to LIMIT in Mysql.
for ex, LIMIT 10,10 in MYSQL returns to me a maximum of 10 records starting from the
10th record in the returned recordset.
is there any similar functionality available in MSSQL.
if not, how should I go about implementing this functionality.
I would also appreciate if someopone could point me to a good tutorial on the subject
using MSSQL server as the database server.
best regards
Ankur Verma
HCL Technologies
A1CD, Sec -16
Noida, UP
India
